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

Explain should indicate when aggregation pipeline optimizations occur

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Aggregation Framework
    • None
    • Query Optimization

    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

        Activity

          People

            backlog-query-optimization Backlog - Query Optimization
            christopher.harris@mongodb.com Chris Harris
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated: