-
Type: Improvement
-
Resolution: Unresolved
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Diagnostics, Querying
-
None
-
Query Execution
-
Fully Compatible
The new query framework should expose statistics around planning and cache utilization.
Question: expose globally or per collection?
Statistics:
- Number of times the cache is dropped (should we distinguish whether from write operations or index drop/raise?)
- Number of times a plan is evicted from the cache
- LRU evictions
- Feedback evictions
- Cumulative time spent planning
- Average number of plans considered per query shape
Currently we drop plan cache entries and all associated statistics before allowing a new plan into the cache for the query shape. One way to achieve better execution stats over time for the query engine would be to maintain historical data in the plan cache.
- is duplicated by
-
SERVER-18013 Expose more execution stats from plan cache introspection commands
- Closed
-
SERVER-18466 Log when and why a query shape begins to use a different plan
- Closed
- is related to
-
SERVER-26084 Add statement-level statistics to the query plan cache (or elsewhere)
- Open
-
SERVER-5828 Metric/Stats Tracking
- Closed
-
SERVER-14959 Increase logging of query plan cache operations
- Closed
-
SERVER-18013 Expose more execution stats from plan cache introspection commands
- Closed