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

Users should be able to request that explain not bypass the plan cache

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Backlog
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Querying
    • Labels:
    • Sprint:
      Query 2020-11-30, Query 2020-12-14, Query 2020-12-28, Query 2021-01-11, Query 2021-01-25, Query Execution 2021-02-22, Query Execution 2021-03-08, Query Execution 2021-03-22
    • Case:

      Description

      Users should be able to request that explain not bypass the plan cache. This would enable users to more easily retrieve stats information about queries run against with the shape's current cached plan, to aid in introspection when diagnosing query performance issues.

      Users can get similar functionality today by using getPlansByQuery() to look up the currently cached plan and then requesting an explain of a hinted query against that plan. However, not all plans can be hinted (for example, multi-index plans cannot be hinted). Also, making this a 1-step process would improve usability.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-execution Backlog - Query Execution
              Reporter:
              rassi J Rassi
              Participants:
              Votes:
              2 Vote for this issue
              Watchers:
              13 Start watching this issue

                Dates

                Created:
                Updated: