[SERVER-79062] Either block from lowering to SBE or support whole bucket match TS queries Created: 18/Jul/23 Updated: 17/Oct/23 Resolved: 23/Aug/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Irina Yatsenko (Inactive) | Assignee: | Backlog - Query Integration |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Assigned Teams: |
Query Integration
|
||||||||
| Participants: | |||||||||
| Description |
|
This optimization is done for $match on the time field (the value in $match must be of type BSONDate, the optimization doesn't kick in for doubles) and avoids applying the event filter to each measurement in the bucket. The optimization is implemented via an optional state on $_internalUnpackBucket. According to Arun Banala the optimization improved the eligible queries by up to 30% so we don’t want to lose it but if it ends up tricky to implement in SBE we would need to block these queries from being lowered. |