| Orders |
systemID, createdAt
|
19x |
129.1 ms |
188 ms |
-
|
46588
|
⚠ No index proposed — The index for this filter already exists (systemID, createdAt). The remaining cost is "reason" is not a field of Orders — $addFields computes it from "reasonDocs.reasons". Needs manual inspection: index the filter that runs BEFORE the first $project/$addFields/$lookup, or move the filter earlier so it can be indexed.
|
| Orders |
systemID, inventoryStatus.warehouse, createdAt
|
7x |
167.0 ms |
249 ms |
-
|
8183
|
db["Orders"].createIndex({"systemID": 1, "inventoryStatus.warehouse": 1, "createdAt": -1});
|
| Orders |
systemID, type, inventoryStatus.sales, counter.no_answer, salesDetails.assignee
|
8x |
111.4 ms |
119 ms |
-
|
7128
|
db["Orders"].createIndex({"systemID": 1, "type": 1, "inventoryStatus.sales": 1, "counter.no_answer": 1, "salesDetails.assignee": 1});
⚠ One value dominates "type", "inventoryStatus.sales", "salesDetails.assignee" in the sample (>60% of documents), so this index is weakly selective there — append a sort key such as createdAt:-1 so the worst case can still stop at the limit.
|
| Orders |
systemID, type, inventoryStatus.sales, counter.no_answer, salesDetails.assignee, createdAt
|
4x |
111.8 ms |
118 ms |
-
|
1788
|
db["Orders"].createIndex({"systemID": 1, "type": 1, "inventoryStatus.sales": 1, "counter.no_answer": 1, "salesDetails.assignee": 1, "createdAt": -1});
⚠ One value dominates "type", "inventoryStatus.sales", "salesDetails.assignee" in the sample (>60% of documents), so this index is weakly selective there — append a sort key such as createdAt:-1 so the worst case can still stop at the limit.
|