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

Explain 'allPlansExecution' output should include the calculated plan ranking score.

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Optimization

      The output of .explain(), particularly with allPlansExecution, should include the calculated plan ranking score.

      This will be particularly helpful when trying to understand why trying to determine when one plan is chosen relative to another. Currently, a user will need to inspect the different stages of a plan execution relative to others, manually calculating the plan score. The "actual" plan score is only shown in the PlanCache output (as far as I'm aware)

            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            adam.harrison@mongodb.com Adam Harrison
            0 Vote for this issue
            4 Start watching this issue