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

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

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Trivial - P5 Trivial - P5
    • None
    • Affects Version/s: 2.5.4
    • Component/s: Admin, Querying
    • None
    • Fully Compatible

      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",
      ...
      

            Assignee:
            david.storch@mongodb.com David Storch
            Reporter:
            craig.harris Craig Harris
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: