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

Explain should indicate when aggregation pipeline optimizations occur

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

      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:
            backlog-query-optimization [DO NOT USE] Backlog - Query Optimization
            Reporter:
            christopher.harris@mongodb.com Chris Harris
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated: