-
Type:
Improvement
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
(copied to CRM)
Sometimes, like in HELP-69798, we suspect that the issues have little or nothing to do with planning time but we cannot really confidently tell since we have not enough visibility metrics into the planner. Therefore we should add FTDC metrics for:
- Query parsing time
- Qiery optimization time, defined as time spent into any heuristic optimizations we make to a CanonicalQuery (e.g: match expression optimization)
- Plan enumeration time
- Query planning time (time spent multi-planning)
- Time spent in SBE stagebuilders (if query was SBE eligible)
- Number of keys not found vs found but inactive vs found and active in plan cache
- Time waiting for the partitioned cache lock
- Time spent retrieving a plan from cache
- related to
-
SERVER-92476 planningTimeMicros can include work not related to planning
-
- Closed
-