Created
February 9, 2016 04:28
-
-
Save saleem-mirza/2fce8f341b8498c4b917 to your computer and use it in GitHub Desktop.
MongoDB Query Explain result
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "queryPlanner" : { | |
| "plannerVersion" : NumberInt(1), | |
| "namespace" : "enron.messages", | |
| "indexFilterSet" : false, | |
| "parsedQuery" : { | |
| "$text" : { | |
| "$search" : "Gillette", | |
| "$language" : "english", | |
| "$caseSensitive" : false, | |
| "$diacriticSensitive" : false | |
| } | |
| }, | |
| "winningPlan" : { | |
| "stage" : "LIMIT", | |
| "limitAmount" : NumberInt(1), | |
| "inputStage" : { | |
| "stage" : "TEXT", | |
| "indexPrefix" : { | |
| }, | |
| "indexName" : "body_text", | |
| "parsedTextQuery" : { | |
| "terms" : [ | |
| "gillett" | |
| ], | |
| "negatedTerms" : [ | |
| ], | |
| "phrases" : [ | |
| ], | |
| "negatedPhrases" : [ | |
| ] | |
| }, | |
| "inputStage" : { | |
| "stage" : "TEXT_MATCH", | |
| "inputStage" : { | |
| "stage" : "TEXT_OR", | |
| "inputStage" : { | |
| "stage" : "IXSCAN", | |
| "keyPattern" : { | |
| "_fts" : "text", | |
| "_ftsx" : NumberInt(1) | |
| }, | |
| "indexName" : "body_text", | |
| "isMultiKey" : true, | |
| "isUnique" : false, | |
| "isSparse" : false, | |
| "isPartial" : false, | |
| "indexVersion" : NumberInt(1), | |
| "direction" : "backward", | |
| "indexBounds" : { | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }, | |
| "rejectedPlans" : [ | |
| ] | |
| }, | |
| "executionStats" : { | |
| "executionSuccess" : true, | |
| "nReturned" : NumberInt(1), | |
| "executionTimeMillis" : NumberInt(90840), | |
| "totalKeysExamined" : NumberInt(4645487), | |
| "totalDocsExamined" : NumberInt(4645487), | |
| "executionStages" : { | |
| "stage" : "LIMIT", | |
| "nReturned" : NumberInt(1), | |
| "executionTimeMillisEstimate" : NumberInt(88510), | |
| "works" : NumberInt(4645491), | |
| "advanced" : NumberInt(1), | |
| "needTime" : NumberInt(4645489), | |
| "needYield" : NumberInt(0), | |
| "saveState" : NumberInt(36560), | |
| "restoreState" : NumberInt(36560), | |
| "isEOF" : NumberInt(1), | |
| "invalidates" : NumberInt(0), | |
| "limitAmount" : NumberInt(1), | |
| "inputStage" : { | |
| "stage" : "TEXT", | |
| "nReturned" : NumberInt(1), | |
| "executionTimeMillisEstimate" : NumberInt(88300), | |
| "works" : NumberInt(4645490), | |
| "advanced" : NumberInt(1), | |
| "needTime" : NumberInt(4645489), | |
| "needYield" : NumberInt(0), | |
| "saveState" : NumberInt(36560), | |
| "restoreState" : NumberInt(36560), | |
| "isEOF" : NumberInt(0), | |
| "invalidates" : NumberInt(0), | |
| "indexPrefix" : { | |
| }, | |
| "indexName" : "body_text", | |
| "parsedTextQuery" : { | |
| "terms" : [ | |
| "gillett" | |
| ], | |
| "negatedTerms" : [ | |
| ], | |
| "phrases" : [ | |
| ], | |
| "negatedPhrases" : [ | |
| ] | |
| }, | |
| "inputStage" : { | |
| "stage" : "TEXT_MATCH", | |
| "nReturned" : NumberInt(1), | |
| "executionTimeMillisEstimate" : NumberInt(88040), | |
| "works" : NumberInt(4645490), | |
| "advanced" : NumberInt(1), | |
| "needTime" : NumberInt(4645489), | |
| "needYield" : NumberInt(0), | |
| "saveState" : NumberInt(36560), | |
| "restoreState" : NumberInt(36560), | |
| "isEOF" : NumberInt(0), | |
| "invalidates" : NumberInt(0), | |
| "docsRejected" : NumberInt(0), | |
| "inputStage" : { | |
| "stage" : "TEXT_OR", | |
| "nReturned" : NumberInt(1), | |
| "executionTimeMillisEstimate" : NumberInt(87930), | |
| "works" : NumberInt(4645490), | |
| "advanced" : NumberInt(1), | |
| "needTime" : NumberInt(4645489), | |
| "needYield" : NumberInt(0), | |
| "saveState" : NumberInt(36560), | |
| "restoreState" : NumberInt(36560), | |
| "isEOF" : NumberInt(0), | |
| "invalidates" : NumberInt(0), | |
| "docsExamined" : NumberInt(4645487), | |
| "inputStage" : { | |
| "stage" : "IXSCAN", | |
| "nReturned" : NumberInt(4645487), | |
| "executionTimeMillisEstimate" : NumberInt(12160), | |
| "works" : NumberInt(4645488), | |
| "advanced" : NumberInt(4645487), | |
| "needTime" : NumberInt(0), | |
| "needYield" : NumberInt(0), | |
| "saveState" : NumberInt(36560), | |
| "restoreState" : NumberInt(36560), | |
| "isEOF" : NumberInt(1), | |
| "invalidates" : NumberInt(0), | |
| "keyPattern" : { | |
| "_fts" : "text", | |
| "_ftsx" : NumberInt(1) | |
| }, | |
| "indexName" : "body_text", | |
| "isMultiKey" : true, | |
| "isUnique" : false, | |
| "isSparse" : false, | |
| "isPartial" : false, | |
| "indexVersion" : NumberInt(1), | |
| "direction" : "backward", | |
| "indexBounds" : { | |
| }, | |
| "keysExamined" : NumberInt(4645487), | |
| "dupsTested" : NumberInt(4645487), | |
| "dupsDropped" : NumberInt(0), | |
| "seenInvalidated" : NumberInt(0) | |
| } | |
| } | |
| } | |
| } | |
| }, | |
| "allPlansExecution" : [ | |
| ] | |
| }, | |
| "serverInfo" : { | |
| "host" : "xxxxxxxxxxx", | |
| "port" : NumberInt(27017), | |
| "version" : "3.2.0", | |
| "gitVersion" : "45d947729a0315accb6d4f15a6b06be6d9c19fe7" | |
| }, | |
| "ok" : NumberInt(1) | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment