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

Add and expose statistics to new query framework

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Backlog
    • Major - P3
    • Resolution: Unresolved
    • None
    • None
    • Diagnostics, Querying
    • None
    • Query Execution
    • Fully Compatible

    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.

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18013 Expose more execution stats from plan cache introspection commands

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18466 Log when and why a query shape begins to use a different plan

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-26084 Add statement-level statistics to the query plan cache (or elsewhere)

          • Major - P3 - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-5828 Metric/Stats Tracking

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-14959 Increase logging of query plan cache operations

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18013 Expose more execution stats from plan cache introspection commands

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              backlog-query-execution Backlog - Query Execution
              dan@mongodb.com Daniel Pasette (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated: