[SERVER-26084] Add statement-level statistics to the query plan cache (or elsewhere) Created: 09/Sep/16  Updated: 06/Dec/22

Status: Open
Project: Core Server
Component/s: Diagnostics, Querying, WiredTiger
Affects Version/s: None
Fix Version/s: Needs Further Definition

Type: New Feature Priority: Major - P3
Reporter: Shakir Sadikali Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 6
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-13220 Add and expose statistics to new quer... Backlog
Assigned Teams:
Query Execution
Participants:

 Description   

The current timeseries implementation allows us to infer how often WT I/O requests result in a WT cache hit vs not.

I define a logical I/O as a single request for a block or page (whatever our most granular request is) whether from cache or disk.

Is there explicit tooling that would let us

  • aggregate the actual number of logical I/Os for a given query shape
  • aggregate the actual number of logical I/Os for all query shapes

and then for the above

  • aggregate the number of times the logical I/O was serviced by a WT cache hit
  • aggregate the number of times the logical I/O was serviced by a filesystem cache hit
  • aggregate the number of times the logical I/O resulted in a physical I/O request


 Comments   
Comment by Asya Kamsky [ 16/Apr/20 ]

Note that the storage access piece of this was implemented in SERVER-38240 and is available in 4.0.9 and later.

Generated at Thu Feb 08 04:11:06 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.