[SERVER-32721] Explain output should indicate when a backup plan is used Created: 16/Jan/18  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Nicholas Zolnierz Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 1
Labels: neweng
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
Assigned Teams:
Query Execution
Participants:
Case:

 Description   

During the investigation of a slow query, the query planner used different plans when running explain: "queryPlanner" vs. explain: "executionStats". The reason that this happened is because the original winning plan ran out of memory in the "executionStats" mode, and so the planner fell back to the backup plan. It would be helpful if the explain output included some indication when this happens.


Generated at Thu Feb 08 04:31:05 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.