Skip to content

Instantly share code, notes, and snippets.

@saleem-mirza

saleem-mirza/explain.json

Created February 9, 2016 04:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save saleem-mirza/2fce8f341b8498c4b917 to your computer and use it in GitHub Desktop.
Save saleem-mirza/2fce8f341b8498c4b917 to your computer and use it in GitHub Desktop.
Download ZIP
MongoDB Query Explain result
Raw
explain.json
{
"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