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

Explain output should indicate when a backup plan is used

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Querying
    • Labels:
    • Case:

      Description

      During the investigation of a slow query, the query planner used different plans when running explain: "queryPlanner" vs. explain: "executionStats". The reason that this happened is because the original winning plan ran out of memory in the "executionStats" mode, and so the planner fell back to the backup plan. It would be helpful if the explain output included some indication when this happens.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-execution Backlog - Query Execution
              Reporter:
              nicholas.zolnierz Nicholas Zolnierz
              Participants:
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated: