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

Include sort (spec) for sort stage in full explain output

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Trivial - P5
    • Resolution: Duplicate
    • Affects Version/s: 2.5.4
    • Fix Version/s: None
    • Component/s: Admin, Querying
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible

      Description

      I expected/wanted to see the sort spec when running this:

      db.temp.find( {a:1} ).limit(3).sort( {b:1, _id:1} ).explain(true)
      ...
              "stats" : {
                      "type" : "SORT",
                      "works" : 11,
                      "yields" : 0,
                      "unyields" : 0,
                      "invalidates" : 0,
                      "advanced" : 3,
                      "needTime" : 7,
                      "needFetch" : 0,
                      "isEOF" : 1,
                      "forcedFetches" : 0,
                      "children" : [
                              {
                                      "type" : "FETCH",
      ...

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: