Open jeroen opened 2 years ago
Might need a better index for this
mongo | {"t":{"$date":"2021-12-28T22:04:11.364+00:00"},"s":"I", "c":"COMMAND", "id":51803, "ctx":"conn6","msg":"Slow query","attr":{"type":"command","ns":"cranlike.packages","command":{"find":"packages","filter":{"_registered":true,"_type":{"$in":["src","failure"]},"$or":[{"_user":"ropensci"},{"_builder.maintainer.login":"ropensci","_selfowned":true}]},"sort":{"_builder.commit.time":-1},"projection":{"_id":0,"maintainer":"$Maintainer","package":"$Package","version":"$Version","description":"$Description","updated":"$_builder.commit.time","vignettes":"$_builder.vignettes","status":"$_builder.status","upstream":"$_builder.upstream","buildlog":"$_builder.url","repository":"$Repository","type":"$_type","user":"$_user"},"limit":50,"returnKey":false,"showRecordId":false,"collation":{"locale":"en_US","numericOrdering":true},"lsid":{"id":{"$uuid":"375fc1b6-002a-41bd-8121-55e163cae375"}},"$db":"cranlike"},"planSummary":"COLLSCAN","keysExamined":0,"docsExamined":16602,"hasSortStage":true,"cursorExhausted":true,"numYields":17,"nreturned":50,"queryHash":"FD371C3A","planCacheKey":"A9149B96","reslen":63086,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":18}},"Global":{"acquireCount":{"r":18}},"Database":{"acquireCount":{"r":18}},"Collection":{"acquireCount":{"r":18}},"Mutex":{"acquireCount":{"r":1}}},"storage":{},"protocol":"op_msg","durationMillis":100}}
Might need a better index for this