[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)


Generated at Thu Feb 08 06:24:50 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.