Details
-
Improvement
-
Resolution: Unresolved
-
Major - P3
-
None
-
None
-
Query Execution
Description
For covered index queries in agg don't hydrate field names before converting to Document.
"$cursor" : { |
"query" : { |
"type" : "Music" |
},
|
"fields" : { |
"format" : 1, |
"genre" : 1, |
"subclass" : 1, |
"_id" : 0 |
},
|
"queryPlanner" : { |
"plannerVersion" : 1, |
"namespace" : "bestbuy.products", |
"indexFilterSet" : false, |
"parsedQuery" : { |
"type" : { |
"$eq" : "Music" |
}
|
},
|
"winningPlan" : { |
"stage" : "PROJECTION", |
"transformBy" : { |
"format" : 1, |
"genre" : 1, |
"subclass" : 1, |
"_id" : 0 |
},
|
"inputStage" : { |
"stage" : "IXSCAN", |
"keyPattern" : { |
"type" : 1, |
"subclass" : 1, |
"genre" : 1, |
"format" : 1 |
},
|
"indexName" : "type_1_subclass_1_genre_1_format_1", |
"isMultiKey" : false, |
"multiKeyPaths" : { |
"type" : [ ], |
"subclass" : [ ], |
"genre" : [ ], |
"format" : [ ] |
},
|
"isUnique" : false, |
"isSparse" : false, |
"isPartial" : true, |
"indexVersion" : 2, |
"direction" : "forward", |
"indexBounds" : { |
"type" : [ |
"[\"Music\", \"Music\"]" |
],
|
"subclass" : [ |
"[MinKey, MaxKey]" |
],
|
"genre" : [ |
"[MinKey, MaxKey]" |
],
|
"format" : [ |
"[MinKey, MaxKey]" |
]
|
}
|
}
|
},
|
"rejectedPlans" : [ ] |
}
|
}
|
Ideally this would eliminate "stage" : "PROJECTION" or replace it with agg specific stage.