[SERVER-13220] Add and expose statistics to new query framework Created: 15/Mar/14  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: Diagnostics, Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Daniel Pasette (Inactive) Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-18013 Expose more execution stats from plan... Closed
is duplicated by SERVER-18466 Log when and why a query shape begins... Closed
Related
is related to SERVER-26084 Add statement-level statistics to the... Open
is related to SERVER-5828 Metric/Stats Tracking Closed
is related to SERVER-14959 Increase logging of query plan cache ... Closed
is related to SERVER-18013 Expose more execution stats from plan... Closed
Assigned Teams:
Query Execution
Backwards Compatibility: Fully Compatible
Participants:

 Description   

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.


Generated at Thu Feb 08 03:31:01 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.