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