standard_queries_for_index_testing.js

// db.genomes.find({"$or":[{"public":true,"binned":false,"uploadedAt":"2024-07-19T14:24:49.627Z"},{"_user":"5f1ee03cd36dc0d9118f0c00","binned":false,"uploadedAt":"2024-07-19T14:24:49.627Z"}]}).explain("executionStats")// db.genomes.distinct("analysis.mlst.st", {})
db.genomes.find({"$or":[{"public":true,"binned":false,"uploadedAt":ISODate("2024-07-19T14:24:49.627Z")},{"_user":"5f1ee03cd36dc0d9118f0c00","binned":false,"uploadedAt":ISODate("2024-07-19T14:24:49.627Z")}]}).sort({createdAt: -1}).explain("executionStats")// db.genomes.distinct("analysis.mlst.st", {})
db.genomes.find({"analysis.kleborate.typing.O_locus": "O3b", "public":true,"binned":false,"analysis.speciator.speciesId":"573","analysis.speciator.genusId":"570"}).sort({createdAt: -1}).explain("executionStats")
db.genomes.find({"public":true,"binned":false,"analysis.speciator.speciesId":"1280","analysis.speciator.genusId":"1279","analysis.mlst.st":"15"}).sort({createdAt: -1}).explain("executionStats")
db.genomes.find({"_user": ObjectId("5f1ee03cd36dc0d9118f0c00")},{ "uploadedAt":1,"upload":1,"fileId":1}).explain("executionStats")
db.genomes.find({"$or":[{"public":true,"binned":false,"analysis.metrics":{"$exists":true},"analysis.speciator.genusId":"194"},{"_user":"5f1ee03cd36dc0d9118f0c00","binned":false,"analysis.metrics":{"$exists":true},"analysis.speciator.genusId":"194"}]}).sort({"createdAt": -1})
db.genomes.find({"$or":[{"public":true,"binned":false,"analysis.metrics":{"$exists":true},"analysis.speciator.genusId":"194"}, {"_user":"5f1ee03cd36dc0d9118f0c00","binned":false,"analysis.metrics":{"$exists":true},"analysis.speciator.genusId":"194"}]}).sort({"createdAt": -1}).explain("executionStats")
db.genomes.find({"public":true,"binned":false,"analysis.metrics":{"$exists":true},"analysis.speciator.genusId":"194"}).sort({"createdAt": -1}).explain("executionStats")