Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-14488

Investigate changes in SERVER-56484: SBE explain execution stats include both "nReturned" and "advanced", which duplicate each other

    XMLWordPrintable

    Details

    • Type: Task
    • Status: External Review
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 5.0.0-rc0, 5.1.0-rc0
    • Component/s: manual, Server
    • Labels:
      None

      Description

      Description

      Downstream Change Summary

      The change modifies ouput of explain("executionStats").executionStats in SBE mode.

      Description of Linked Ticket

      When we display the full execution stats associated with an SBE plan in explain, each SBE stage reports both nReturned and advanced. For example:

      			"stage" : "nlj",
      			"planNodeId" : 1,
      			"nReturned" : 3,
      			"executionTimeMillisEstimate" : 0,
      			"advances" : 3,
      			"opens" : 1,
      			"closes" : 1,
      			"saveState" : 0,
      			"restoreState" : 0,
      			"isEOF" : 1,
      			"innerOpens" : 1,
      			"innerCloses" : 1,
      			"outerProjects" : [
      				NumberLong(4)
      			],
      			"outerCorrelated" : [
      				NumberLong(7),
      				NumberLong(8)
      			],
      

      This is a nested loop join stage. It has both nReturned and advanced which are both equal to 3. These two fields have the exact same meaning and report the exact same information. We should eliminate this redundancy. Since nReturned is a well-known field name from the format for explainVersion:"1", we should probably deleted advanced and keep reporting this statistic under the field name nReturned.

      Scope of changes

      Impact to Other Docs

      MVP (Work and Date)

      Resources (Scope or Design Docs, Invision, etc.)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jocelyn.mendez Jocelyn Mendez
              Reporter:
              backlog-server-pm Backlog - Core Eng Program Management Team
              Participants:
              Last commenter:
              Jocelyn Mendez Jocelyn Mendez
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Days since reply:
                27 weeks, 6 days ago
                Date of 1st Reply: