[DOCS-5920] Add missing explain() documentation fields Created: 28/Jul/15  Updated: 11/Jan/17  Resolved: 30/Jul/15

Status: Closed
Project: Documentation
Component/s: None
Affects Version/s: None
Fix Version/s: 01112017-cleanup

Type: Improvement Priority: Major - P3
Reporter: Edision chow Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 7 years, 29 weeks ago

 Description   

Hey guys
The return of executionStats explain is:

 "executionStats" : {
                "executionSuccess" : true,
                "nReturned" : 29861,
                "executionTimeMillis" : 424,
                "totalKeysExamined" : 29861,
                "totalDocsExamined" : 29861,
                "executionStages" : {
                        "stage" : "FETCH",
                        "nReturned" : 29861,
                        "executionTimeMillisEstimate" : 410,
                        "works" : 29862,
                        "advanced" : 29861,
                        "needTime" : 0,
                        "needFetch" : 0,
                        "saveState" : 234,
                        "restoreState" : 234,
                        "isEOF" : 1,
                        "invalidates" : 0,
                        "docsExamined" : 29861,
                        "alreadyHasObj" : 0,
                        "inputStage" : {
                                "stage" : "IXSCAN",
                                "nReturned" : 29861,
                                "executionTimeMillisEstimate" : 20,
                                "works" : 29862,
                                "advanced" : 29861,
                                "needTime" : 0,
                                "needFetch" : 0,
                                "saveState" : 234,
                                "restoreState" : 234,
                                "isEOF" : 1,
                                "invalidates" : 0,
                                "keyPattern" : {
                                        "a" : 1,
                                        "b" : 1
                                },
                                "indexName" : "a_1_b_1",
                                "isMultiKey" : false,
                                "direction" : "forward",
                                "indexBounds" : {
                                        "a" : [
                                                "[111.0, 111.0]"
                                        ],
                                        "b" : [
                                                "[MinKey, MaxKey]"
                                        ]
                                },
                                "keysExamined" : 29861,
                                "dupsTested" : 0,
                                "dupsDropped" : 0,
                                "seenInvalidated" : 0,
                                "matchTested" : 0
                        }
                }
        },

But i can`t find the docs of this fileds:

  • works
  • advanced
  • needTime
  • needfetch
  • saveState
  • restoreState
  • isEOF
  • invalidates
  • dupsTested
  • dupsDropped
  • seenInvalidated
  • matchTested

Could u pls tell me what the meaning of this fileds?

Thanks



 Comments   
Comment by Emily Hall [ 27/Jul/16 ]

Closed for housekeeping on 7/27/2016 by Emily Hall.
If you require additional support, please open a new ticket for prioritization.
Thanks,
Emily

Comment by Githook User [ 30/Jul/15 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-5920 additional explain results fields
Branch: master
https://github.com/mongodb/docs/commit/21cfa9e4d1c20edcc05a091cb37ae466a066e06d

Comment by Ramon Fernandez Marina [ 28/Jul/15 ]

Thanks for your report eshujiushiwo. The fields you mention do not appear in the Explain Results documentation, so I'm converting this into a DOCS ticket to enhance such documentation.

Thanks,
Ramón.

Generated at Thu Feb 08 07:51:16 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.