-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Execution
-
Fully Compatible
-
v7.0, v6.0
-
QE 2024-03-18, QE 2024-04-01
-
(copied to CRM)
In SBE, if you run explain("allPlansExecution") on a query that have extra pipeline stages pushed down (for example, $group), execution stats for rejected plans will be all zeros.
That is because we extend rejected plans with aggregation pipeline only in explain(), resetting execution stats.
allPlansExecution is an important debug tool for SBE multi planner that we should fix.
For example, for allPlansExecution purposes, we don't have to extend the plans with an agg pipeline, because agg pipeline doesn't affect plan selection anyway. This is the way it is done in classic multiplanner for SBE.
Also, users on version 6.0 and 7.0 only use SBE when we have a $group or $lookup, so this is completely broken for them. We should fix and backport this.
- is depended on by
-
COMPASS-7776 Investigate changes in SERVER-87124: Correctly fill execution stats for allPlansExecution when cqPipeline is present
-
- Closed
-
-
TOOLS-3502 Investigate changes in SERVER-87124: Correctly fill execution stats for allPlansExecution when cqPipeline is present
-
- Closed
-
- is related to
-
SERVER-99218 Drop collection "test" at start of explain_all_plans_execution_stats.js
-
- Closed
-