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

explain - output and how to interpret

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v1.3.15, mongodb-3.0
    • Component/s: manual
    • Labels:
      None
    • # Replies:
      1
    • Last comment by Customer:
      true
    • Actual Time:
      16

      Description

      Main sections:
      "queryPlanner", "executionStats", "allPlansExecution", and "serverInfo".

      Key fields from the most important stages, like IXSCAN and FETCH + some mapping of old fields to new fields
      Explain tree structure of queryPlanner.winningPlan and executionStats.executionStats.

      /reference/method/cursor.explain()
      /core/query-plans
      /tutorial/analyze-query-plan
      /core/query-optimization
      /tutorial/measure-index-use
      /reference/operator/meta/explain
      /tutorial/evaluate-operation-performance

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kay.kim Kay Kim
                Reporter:
                kay.kim Kay Kim
                Participants:
                Last commenter:
                Jonathan Dahl
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since reply:
                  5 years ago
                  Date of 1st Reply: