-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Querying
-
Query Execution
-
Query 2020-11-30, Query 2020-12-14, Query 2020-12-28, Query 2021-01-11, Query 2021-01-25, Query Execution 2021-02-22, Query Execution 2021-03-08, Query Execution 2021-03-22, QE 2023-08-21, QE 2023-09-04, QE 2023-09-18, QE 2023-10-02, QE 2023-10-16, QE 2023-10-30
-
(copied to CRM)
Users should be able to request that explain not bypass the plan cache. This would enable users to more easily retrieve stats information about queries run against with the shape's current cached plan, to aid in introspection when diagnosing query performance issues.
Users can get similar functionality today by using getPlansByQuery() to look up the currently cached plan and then requesting an explain of a hinted query against that plan. However, not all plans can be hinted (for example, multi-index plans cannot be hinted). Also, making this a 1-step process would improve usability.
- is duplicated by
-
SERVER-37423 query does not use same execution plan w/wo explain(executionStats)
- Closed
- is related to
-
SERVER-40361 Reduce memory footprint of plan cache entries
- Closed
-
SERVER-82238 Add field to explain to indicate if winning and rejected plans are cached
- Closed
- related to
-
SERVER-77859 Add parameter is explain with 'executionStats' output to indicate if plan cache is used
- Closed