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

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Querying
    • Query Execution
    • 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, QE 2023-08-21, QE 2023-09-04, QE 2023-09-18, QE 2023-10-02, QE 2023-10-16, QE 2023-10-30

    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

        Activity

          People

            backlog-query-execution Backlog - Query Execution
            rassi J Rassi
            Votes:
            4 Vote for this issue
            Watchers:
            28 Start watching this issue

            Dates

              Created:
              Updated: