Investigate changes in SERVER-73498: Add time spent in the multi-planner to the explain output

XMLWordPrintableJSON

    • Type: Investigation
    • Resolution: Done
    • Priority: Major - P3
    • No version
    • Affects Version/s: None
    • Component/s: None
    • None
    • Not Needed
    • Developer Tools

      Original Downstream Change Summary

      I'm not adding a new field here but populating it instead (was always 0). The field in particular is queryPlanner.optimizationTimeMillis

      Description of Linked Ticket

      Add a parameter to the explain output indicating the time spent evaluating the candidate plans in the multi-planner. There are some scenarios where the the multi-planner ends up taking a lot more time than the actual query execution. We should probably add this parameter conditionally if the time spend multi-planning exceeded certain threshold (maybe 100ms)

              Assignee:
              Unassigned
              Reporter:
              Backlog - Core Eng Program Management Team
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: