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

[CQF] Expose physical ABT in queryPlanner explain for M2

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Query Optimization
    • Fully Compatible
    • QO 2023-10-02, QO 2023-10-16, QO 2023-10-30, QO 2023-11-13

      This ticket exposes the physical ABT in the queryPlanner output under winningPlan.queryPlan. This may involve adding a new version to the optimizer::ExplainVersion enum. It also adds the queryFramework field to the explain output if the framework used was CQF. It also takes care of EOF stage plans (for example, query on an empty collection).

       

      Follow up work, which has been split off into tickets linked to this one, includes but is not limited to:

      • Expose the physical ABT in the queryPlanner output under winningPlan.queryPlan. This may involve adding a new version to the optimizer::ExplainVersion enum.
      • Investigate whether projection names in explain plans can be "descriptive" (see internalCascadesOptimizerUseDescriptiveVarNames)
      • Omit the classic-only fields from the queryPlanner output
      • Add CQF-specific fields to the output, such as maxPartialSchemaReqCountReached.
      • Update the parsedQuery field to include the input query passed to the ABT translation component 
      • Ensure the server parameters list includes internalQueryCardinalityEstimatorMode and internalQueryFrameworkControl – possibly this should wait until we have a decision on exposing "bonsai"
      • Bump the explain version to v3
      • As a final check: ensure the explain output matches the examples in the syntax document

            Assignee:
            militsa.sotirova@mongodb.com Militsa Sotirova
            Reporter:
            hana.pearlman@mongodb.com Hana Pearlman
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: