Extend $planCacheStats with top N queryShapeHashes to enable correlating with $queryStats

XMLWordPrintableJSON

    • Type: Task
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Execution
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      At the moment, $planCacheStats reports the planCacheShapeHash / planCacheKey, while $queryStats reports the 'queryShapeHash'. As such, there is no way to correlate the information reported by both.

      This ticket requests extending $planCacheStats to include the top N queryShapeHash values for each plan cache entry (where 'N' can be some constant like 5 or 10). How we decide what the 'top N queryShapeHashes' are is an open question, but it should be relatively cheap to do.

      The ability to correlate these two sources would provide insight into what data access plans are used to answer which queryShapes.

            Assignee:
            Unassigned
            Reporter:
            Mihai Andrei
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: