[SERVER-73498] Add time spent in the multi-planner to the explain output Created: 31/Jan/23 Updated: 17/Feb/23 |
|
| Status: | Open |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Arun Banala | Assignee: | Backlog - Query Optimization |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | quick-win | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Assigned Teams: |
Query Optimization
|
| Participants: |
| Description |
|
Add a parameter to the explain output indicating the time spent evaluating the candidate plans in the multi-planner. There are some scenarios where the the multi-planner ends up taking a lot more time than the actual query execution. We should probably add this parameter conditionally if the time spend multi-planning exceeded certain threshold (maybe 100ms) |