[COMPASS-5878] Handle indexes in $lookup stage Created: 07/Jun/22  Updated: 26/Jun/22  Resolved: 10/Jun/22

Status: Closed
Project: Compass
Component/s: Aggregation pipeline, Explain
Affects Version/s: None
Fix Version/s: 1.32.3

Type: Task Priority: Major - P3
Reporter: Basit Chonka Assignee: Basit Chonka
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: File lookup_explain.json    
Issue Links:
Documented
Epic Link: COMPASS-5281
Documentation Changes: Needed

 Description   

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}

 Comments   
Comment by Githook User [ 26/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: COMPASS-5674-update-schema-toolbar
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 17/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: COMPASS-5673-query-bar
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 16/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: COMPASS-5675-update-explain-toolbar
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 15/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: 1.32-releases
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 14/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: save-and-connect
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 13/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: update-compass-crud-to-shared-config
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 10/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: COMPASS-5874-e2e-copied-encrypted-field-is-not-editable
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 10/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: feat(explain-plan-helper): add support for indexes in stages COMPASS-5878 (#3169)
Branch: main
https://github.com/mongodb-js/compass/commit/2618f65c603d64a3b9426022a35f5f5c703eabfb

Comment by Githook User [ 08/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: Merge branch 'main' into COMPASS-5878-handle-indexes-in-stages
Branch: COMPASS-5878-handle-indexes-in-stages
https://github.com/mongodb-js/compass/commit/eccb33585b0f1311eddae48da120d18c9d8ba411

Comment by Githook User [ 08/Jun/22 ]

Author:

{'name': 'Basit', 'email': 'basit.chonka@mongodb.com', 'username': 'mabaasit'}

Message: Merge branch 'main' of github.com:mongodb-js/compass into COMPASS-5878-handle-indexes-in-stages
Branch: COMPASS-5878-handle-indexes-in-stages
https://github.com/mongodb-js/compass/commit/ae0c08b9f7bd6ab96b3ed135339760967573eb2d

Comment by Githook User [ 07/Jun/22 ]

Author:

{'name': 'Basit', 'email': 'basit.chonka@mongodb.com', 'username': 'mabaasit'}

Message: Merge branch 'COMPASS-5878-handle-indexes-in-stages' of github.com:mongodb-js/compass into COMPASS-5878-handle-indexes-in-stages
Branch: COMPASS-5878-handle-indexes-in-stages
https://github.com/mongodb-js/compass/commit/1af26e5a31247f4689d6e9b682f03bc774c8c101

Comment by Githook User [ 07/Jun/22 ]

Author:

{'name': 'Basit', 'email': '1305718+mabaasit@users.noreply.github.com', 'username': 'mabaasit'}

Message: Merge branch 'main' into COMPASS-5878-handle-indexes-in-stages
Branch: COMPASS-5878-handle-indexes-in-stages
https://github.com/mongodb-js/compass/commit/f0a6408f015ef9959e0dee803e7903daa8a622b7

Generated at Wed Feb 07 22:41:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.