-
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}