mongos> db.exomevars.count({"variant.chr":1,"variant.pos":13302,"variant.ref":"C","variant.alt":"T","genotype.GT":"0/0","sample.tags":{ $nin: ["european","mongo"] } }) 46 mongos> db.exomevars.count({"variant.chr":1,"variant.pos":13302,"variant.ref":"C","variant.alt":"T","genotype.GT":"0/0","sample.tags":{ $nin: ["european","mongo"] } }).explain() Wed May 29 20:19:59.338 JavaScript execution failed: TypeError: Object 46 has no method 'explain' mongos> db.exomevars.find({"variant.chr":1,"variant.pos":13302,"variant.ref":"C","variant.alt":"T","genotype.GT":"0/0","sample.tags":{ $nin: ["european","mongo"] } }).explain() { "clusteredType" : "ParallelSort", "shards" : { "10.55.3.156:27018" : [ { "cursor" : "BtreeCursor variant.chr_1_variant.pos_1_variant.ref_1_variant.alt_1_genotype.GT_1_sample.tags_1", "isMultiKey" : true, "n" : 13, "nscannedObjects" : 5303042, "nscanned" : 6634968, "nscannedObjectsAllPlans" : 5303042, "nscannedAllPlans" : 6634968, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 24, "nChunkSkips" : 0, "millis" : 24649, "indexBounds" : { "variant.chr" : [ [ 1, 1 ] ], "variant.pos" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.ref" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.alt" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "genotype.GT" : [ [ "0/0", "0/0" ] ], "sample.tags" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ] }, "server" : "shard01:27018" } ], "10.55.3.157:27018" : [ { "cursor" : "BtreeCursor variant.chr_1_variant.pos_1_variant.ref_1_variant.alt_1_genotype.GT_1_sample.tags_1", "isMultiKey" : true, "n" : 15, "nscannedObjects" : 5220731, "nscanned" : 6545577, "nscannedObjectsAllPlans" : 5220731, "nscannedAllPlans" : 6545577, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 25, "nChunkSkips" : 0, "millis" : 25073, "indexBounds" : { "variant.chr" : [ [ 1, 1 ] ], "variant.pos" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.ref" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.alt" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "genotype.GT" : [ [ "0/0", "0/0" ] ], "sample.tags" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ] }, "server" : "shard02:27018" } ], "10.55.3.158:27018" : [ { "cursor" : "BtreeCursor variant.chr_1_variant.pos_1_variant.ref_1_variant.alt_1_genotype.GT_1_sample.tags_1", "isMultiKey" : true, "n" : 8, "nscannedObjects" : 5309728, "nscanned" : 6640828, "nscannedObjectsAllPlans" : 5309728, "nscannedAllPlans" : 6640828, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 25, "nChunkSkips" : 0, "millis" : 24549, "indexBounds" : { "variant.chr" : [ [ 1, 1 ] ], "variant.pos" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.ref" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.alt" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "genotype.GT" : [ [ "0/0", "0/0" ] ], "sample.tags" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ] }, "server" : "shard03:27018" } ], "10.55.3.159:27018" : [ { "cursor" : "BtreeCursor variant.chr_1_variant.pos_1_variant.ref_1_variant.alt_1_genotype.GT_1_sample.tags_1", "isMultiKey" : true, "n" : 10, "nscannedObjects" : 5215274, "nscanned" : 6538526, "nscannedObjectsAllPlans" : 5215274, "nscannedAllPlans" : 6538526, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 25, "nChunkSkips" : 0, "millis" : 24185, "indexBounds" : { "variant.chr" : [ [ 1, 1 ] ], "variant.pos" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.ref" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "variant.alt" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ], "genotype.GT" : [ [ "0/0", "0/0" ] ], "sample.tags" : [ [ { "$minElement" : 1 }, { "$maxElement" : 1 } ] ] }, "server" : "shard04:27018" } ] }, "cursor" : "BtreeCursor variant.chr_1_variant.pos_1_variant.ref_1_variant.alt_1_genotype.GT_1_sample.tags_1", "n" : 46, "nChunkSkips" : 0, "nYields" : 99, "nscanned" : 26359899, "nscannedAllPlans" : 26359899, "nscannedObjects" : 21048775, "nscannedObjectsAllPlans" : 21048775, "millisShardTotal" : 98456, "millisShardAvg" : 24614, "numQueries" : 4, "numShards" : 4, "millis" : 25120 } mongos> db.exomevars.count() 318534850