-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Query Integration
-
None
-
None
-
None
-
None
-
None
-
None
-
None
Currently the explain output for count() doesn't include the queryShapeHash, which is inconsistent with explains for other queries supported by query stats, ex find and aggregate.
MongoDB Enterprise > db.coll.explain().count({"x": 9})
{
"explainVersion" : "1",
"queryPlanner" : {
"namespace" : "test.coll",
"parsedQuery" : {
"x" : {
"$eq" : 9
}
},
"indexFilterSet" : false,
"queryHash" : "9BC282AA",
"planCacheShapeHash" : "9BC282AA",
"planCacheKey" : "2455F991",
"optimizationTimeMillis" : 0,
"maxIndexedOrSolutionsReached" : false,
"maxIndexedAndSolutionsReached" : false,
"maxScansToExplodeReached" : false,
"prunedSimilarIndexes" : false,
"winningPlan" : {
"isCached" : false,
"stage" : "COUNT",
"inputStage" : {
"stage" : "COLLSCAN",
"filter" : {
"x" : {
"$eq" : 9
}
},
"nss" : "test.coll",
"direction" : "forward"
}
},
"rejectedPlans" : [ ]
},
"command" : {
"count" : "coll",
"query" : {
"x" : 9
}
},
"serverInfo" : {
"host" : "ip-10-122-5-99",
"port" : 27017,
"version" : "8.3.0-alpha0",
"gitVersion" : "nogitversion"
},
"serverParameters" : {
"internalQueryFacetBufferSizeBytes" : 104857600,
"internalDocumentSourceGroupMaxMemoryBytes" : 104857600,
"internalQueryMaxBlockingSortMemoryUsageBytes" : 104857600,
"internalDocumentSourceSetWindowFieldsMaxMemoryBytes" : 104857600,
"internalQueryFacetMaxOutputDocSizeBytes" : 104857600,
"internalLookupStageIntermediateDocumentMaxSizeBytes" : 104857600,
"internalQueryProhibitBlockingMergeOnMongoS" : 0,
"internalQueryMaxAddToSetBytes" : 104857600,
"internalQueryFrameworkControl" : "trySbeRestricted",
"internalQueryPlannerIgnoreIndexWithCollationForRegex" : 1
},
"ok" : 1
}