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

IndexScan should track the number of calls to seek() and expose in explain

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.3.2
    • Component/s: Querying
    • Backwards Compatibility:
      Fully Compatible
    • Sprint:
      Query 10 (02/22/16)

      Description

      The index scan stage should track the number of calls to BtreeIndexCursor::skip() made here:

      https://github.com/mongodb/mongo/blob/r3.0.0-rc6/src/mongo/db/exec/index_scan.cpp#L438-L439

      Original Description

      Currently nscanned isn't precise enough to distinguish between unindexed traversal and btree traversal, and in some cases between btree skipping and inorder order btree traversal.

        Attachments

          Issue Links

          is documented by

          Task - A task that needs to be done. DOCS-7086 Consider documenting "seeks" IXSCAN statistic added to explain

          • Major - P3 - Major loss of function.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-3414 consider using nscannedObjects in addition to nscanned when selecting a query plan

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-10448 Revamp explain() formatting

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              david.storch David Storch
              Reporter:
              aaron Aaron Staple
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: