[SERVER-86162] Simple $group runs much slower in SBE than Classic engine Created: 02/Feb/24 Updated: 06/Feb/24 |
|
| Status: | Backlog |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 7.3.0-rc1 |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Kevin Cherkauer | Assignee: | Backlog - Query Execution |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
| Assigned Teams: |
Query Execution
|
| Participants: |
| Description |
|
Experiment: Collection0 contains 10,000 docs of the form:
Query:
Per explain execution stats, this runs in
Individual stage time estimates (e) and total actual times from db.Collection0.explain('executionStats'), all in milliseconds: Classic millisecs per stage
SBE millisecs per stage
I will add Genny-based repro instructions in a comment. |