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

Write a JS script to translate "executionStats" section of explain from SBE into classic format

    • Fully Compatible
    • Query Execution 2021-05-03, Query Execution 2021-05-17, Query Execution 2021-05-31, Query Execution 2021-06-14, Query Execution 2021-06-28, Query Execution 2021-07-12, Query Execution 2021-07-26

      The "executionStats" section of the explain output in SBE is drastically different from the classic engine. To help in transitioning from the old to the new format, we need a tool which would allow to convert the "executionStats" section from SBE into classic format.

      The tool would work off the "queryPlanner" section using it as a backbone for the translated "executionStats" section. For each QSN from the "queryPlanner" section we'd need to map it to an SBE sub-tree in the "executionStats" section based on the nodeId, then collect cumulative execution stats for this sub-tree and attach it to a "stage" element in the "executionStats" tree created from the corresponding QSN.

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            anton.korshunov@mongodb.com Anton Korshunov
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: