|
The same applies to the following query, the first in the group of 3, no FETCH is done:
db.collection.find( { a: 5, b: { $in: [ 1, 2, 3 ] } } ).count()
|
replset:PRIMARY> db.movies.explain("executionStats").count({"imdb.rating": 5, countries: {$in: ["Canada", "USA"]} })
|
{
|
"queryPlanner" : {
|
"plannerVersion" : 1,
|
"namespace" : "mflix.movies",
|
"indexFilterSet" : false,
|
"parsedQuery" : {
|
"$and" : [
|
{
|
"imdb.rating" : {
|
"$eq" : 5
|
}
|
},
|
{
|
"countries" : {
|
"$in" : [
|
"Canada",
|
"USA"
|
]
|
}
|
}
|
]
|
},
|
"winningPlan" : {
|
"stage" : "COUNT",
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"keyPattern" : {
|
"imdb.rating" : 1,
|
"countries" : 1
|
},
|
"indexName" : "imdb.rating_1_countries_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"imdb.rating" : [ ],
|
"countries" : [
|
"countries"
|
]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"imdb.rating" : [
|
"[5.0, 5.0]"
|
],
|
"countries" : [
|
"[\"Canada\", \"Canada\"]",
|
"[\"USA\", \"USA\"]"
|
]
|
}
|
}
|
},
|
"rejectedPlans" : [ ]
|
},
|
"executionStats" : {
|
"executionSuccess" : true,
|
"nReturned" : 0,
|
"executionTimeMillis" : 6,
|
"totalKeysExamined" : 361,
|
"totalDocsExamined" : 0,
|
"executionStages" : {
|
"stage" : "COUNT",
|
"nReturned" : 0,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 361,
|
"advanced" : 0,
|
"needTime" : 360,
|
"needYield" : 0,
|
"saveState" : 2,
|
"restoreState" : 2,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"nCounted" : 336,
|
"nSkipped" : 0,
|
"inputStage" : {
|
"stage" : "IXSCAN",
|
"nReturned" : 336,
|
"executionTimeMillisEstimate" : 0,
|
"works" : 361,
|
"advanced" : 336,
|
"needTime" : 24,
|
"needYield" : 0,
|
"saveState" : 2,
|
"restoreState" : 2,
|
"isEOF" : 1,
|
"invalidates" : 0,
|
"keyPattern" : {
|
"imdb.rating" : 1,
|
"countries" : 1
|
},
|
"indexName" : "imdb.rating_1_countries_1",
|
"isMultiKey" : true,
|
"multiKeyPaths" : {
|
"imdb.rating" : [ ],
|
"countries" : [
|
"countries"
|
]
|
},
|
"isUnique" : false,
|
"isSparse" : false,
|
"isPartial" : false,
|
"indexVersion" : 2,
|
"direction" : "forward",
|
"indexBounds" : {
|
"imdb.rating" : [
|
"[5.0, 5.0]"
|
],
|
"countries" : [
|
"[\"Canada\", \"Canada\"]",
|
"[\"USA\", \"USA\"]"
|
]
|
},
|
"keysExamined" : 361,
|
"seeks" : 2,
|
"dupsTested" : 359,
|
"dupsDropped" : 23,
|
"seenInvalidated" : 0
|
}
|
}
|
},
|
"serverInfo" : {
|
"host" : "Daniels-MacBook-Pro-3.local",
|
"port" : 27017,
|
"version" : "3.6.4",
|
"gitVersion" : "d0181a711f7e7f39e60b5aeb1dc7097bf6ae5856"
|
},
|
"ok" : 1,
|
"operationTime" : Timestamp(1527014467, 1),
|
"$clusterTime" : {
|
"clusterTime" : Timestamp(1527014467, 1),
|
"signature" : {
|
"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
|
"keyId" : NumberLong(0)
|
}
|
}
|
}
|
|