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

Explain should indicate when aggregation pipeline optimizations occur

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Aggregation Framework
    • Labels:
      None
    • Case:

      Description

      The optimizer can perform a variety of optimizations on an aggregation pipeline.  These include reordering of stages as well as coalescence.  Such modifications allow the database to improve the performance of the pipeline.  

      To determine if any of these optimizations have happened, a user must be aware of their existence and then compare the stages output from explain with the original pipeline that was submitted.  Explain could help facilitate this process more directly by indicating specific optimizations that were performed.  This could be done via simple boolean flags or could be more complex and list out the transformations individually.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-optimization Backlog - Query Optimization
              Reporter:
              christopher.harris Christopher Harris
              Participants:
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated: