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 (Inactive)
              Reporter:
              kay.kim Kay Kim (Inactive)
              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, 40 weeks, 2 days ago
                Date of 1st Reply: