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

Add and expose statistics to new query framework

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Diagnostics, Querying
    • Labels:
      None
    • Backwards Compatibility:
      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

            Activity

              People

              Assignee:
              backlog-server-query Backlog - Query Team
              Reporter:
              pasette Daniel Pasette
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated: