Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-26084

Add statement-level statistics to the query plan cache (or elsewhere)

    XMLWordPrintable

    Details

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-execution Backlog - Query Execution
              Reporter:
              shakir.sadikali Shakir Sadikali
              Participants:
              Votes:
              6 Vote for this issue
              Watchers:
              69 Start watching this issue

                Dates

                Created:
                Updated: