Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement