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

executionTimeMillisEstimate seems incorrect for some stages

    • Type: Icon: Bug Bug
    • Resolution: Gone away
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 4.4.0-rc1
    • Component/s: Aggregation Framework
    • Labels:
      None
    • ALL

      In SERVER-21784 we added to each stage more details in explain output.

      However, after first stage, every stage seems to show exact same value which is the total time execution of the entire pipeline which seems like a bug.

                    {  "$cursor": {
                             ...
                              },
                              "nReturned" : NumberLong(500000),
                              "executionTimeMillisEstimate" : NumberLong(269)
                      },
                      {
                              "$lookup" : {
                                      ...
                              },
                              "nReturned" : NumberLong(500000),
                              "executionTimeMillisEstimate" : NumberLong(16337)
                      },
                      {
                              "$group" : {
                                    ...
                              },
                              "nReturned" : NumberLong(4000),
                              "executionTimeMillisEstimate" : NumberLong(16337)
                      },
                      {
                              "$group" : {
                                   ...
                              },
                              "nReturned" : NumberLong(1),
                              "executionTimeMillisEstimate" : NumberLong(16337)
                      },
                      {
                              "$project" : {
                                     ...
                              },
                              "nReturned" : NumberLong(1),
                              "executionTimeMillisEstimate" : NumberLong(16337)
                      }
              ],
      

      FYI the explain actually took 16339 ms to run...

            Assignee:
            asya.kamsky@mongodb.com Asya Kamsky
            Reporter:
            asya.kamsky@mongodb.com Asya Kamsky
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: