Explain should indicate when aggregation pipeline optimizations occur

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Aggregation Framework
    • None
    • Query Optimization
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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.

              Assignee:
              [DO NOT USE] Backlog - Query Optimization
              Reporter:
              Chris Harris
              Votes:
              1 Vote for this issue
              Watchers:
              9 Start watching this issue

                Created:
                Updated: