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

Add log line for detailed plan scoring

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.2.0-rc0, 7.0.6, 5.0.26, 6.0.15
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Optimization
    • Fully Compatible
    • v7.0, v6.0, v5.0
    • QO 2023-09-18

      We will update and/or add a log line for detailed plan scoring to include details from the new tiebreaker heuristics. As this is a minor adjustment with limited impact to the scoring algorithm, no adjustments will be made to explain output and the general diagnostic process remains the same. Note that newer versions report the score from the trial phase for “allPlansExectuion” verbosity which would reflect the results of this modified scoring algorithm. We will add a boolean flag to explain when these tie breaker heuristics kick in, a sibling boolean to things like maxIndexedOrSolutionsReached (see SERVER-48625), though I don't think it necessarily always has to show up (eg be reported when false - but no strong opinion there).

            Assignee:
            alexander.ignatyev@mongodb.com Alexander Ignatyev
            Reporter:
            alexander.ignatyev@mongodb.com Alexander Ignatyev
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: