[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: |
|
||||
| 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 |
| Comments |
| Comment by Githook User [ 31/Jan/24 ] |
|
Author: {'name': 'Alexander Ignatyev', 'email': 'alexander.ignatyev@mongodb.com', 'username': 'aligusnet'}Message: (cherry picked from commit ab7a828c01f5f01a1d195fbbbbf36c2f521928de) GitOrigin-RevId: 120256a9bc89cd24668cecdbe71c6cd67a65b80f |
| Comment by Githook User [ 06/Sep/23 ] |
|
Author: {'name': 'Alexander Ignatyev', 'email': 'alexander.ignatyev@mongodb.com', 'username': 'aligusnet'}Message: |