[SERVER-80275] Add log line for detailed plan scoring Created: 21/Aug/23  Updated: 31/Jan/24  Resolved: 06/Sep/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.2.0-rc0, 7.0.6

Type: Task Priority: Major - P3
Reporter: Alexander Ignatyev Assignee: Alexander Ignatyev
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0, v6.0
Sprint: QO 2023-09-18
Participants:

 Description   

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).



 Comments   
Comment by Githook User [ 31/Jan/24 ]

Author:

{'name': 'Alexander Ignatyev', 'email': 'alexander.ignatyev@mongodb.com', 'username': 'aligusnet'}

Message: SERVER-80275 Implement tie breaking heuristics logging

(cherry picked from commit ab7a828c01f5f01a1d195fbbbbf36c2f521928de)

GitOrigin-RevId: 120256a9bc89cd24668cecdbe71c6cd67a65b80f
Branch: v7.0
https://github.com/mongodb/mongo/commit/717a0750ad1735dfce6407844f892a211a1d85e2

Comment by Githook User [ 06/Sep/23 ]

Author:

{'name': 'Alexander Ignatyev', 'email': 'alexander.ignatyev@mongodb.com', 'username': 'aligusnet'}

Message: SERVER-80275 Implement tie breaking heuristics logging
Branch: master
https://github.com/mongodb/mongo/commit/ab7a828c01f5f01a1d195fbbbbf36c2f521928de

Generated at Thu Feb 08 06:43:07 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.