[DOCS-9574] Docs for SERVER-13220: Add and expose statistics to new query framework Created: 05/Dec/16  Updated: 27/Oct/23  Resolved: 08/Dec/17

Status: Closed
Project: Documentation
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Major - P3
Reporter: Emily Hall Assignee: Unassigned
Resolution: Gone away Votes: 0
Labels: delete-docs-tickets
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 6 years, 9 weeks, 5 days ago

 Description   

Engineering Ticket 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.



 Comments   
Comment by Kay Kim (Inactive) [ 08/Dec/17 ]

Opened too soon.

Generated at Thu Feb 08 07:58:41 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.