-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Aggregation pipeline, Explain
-
None
-
Needed
In explain for aggregations, if $lookup stages uses indexes, show those indexes to the user as well.
Reference: Slack
Pipeline:
[{ $lookup: { from: 'transactions', localField: 'account_id', foreignField: 'account_id', as: 'result', pipeline: [] } }]
collection `transactions` has index
{account_id:1, date: 1}