-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
(copied to CRM)
When issuing explain() on aggregate commands with $lookup in it, 'indexesUsed' field is populated with the index that was used as part of the $lookup stage. However, this doesn't happen when $lookup is run on the sharded collection.
This makes it hard to debug and understand which index was used, for both users and us.