Hi Team,
Can you please briefly explain as below fields how to troubleshooting real time when we run explain(executionStats) command.
"executionStats" : {
"executionSuccess" : true,
"nReturned" : 4,
"executionTimeMillis" : 0,
"totalKeysExamined" : 0,
"totalDocsExamined" : 4,
"executionStages" : {
"stage" : "PROJECTION_DEFAULT",
"nReturned" : 4,
"executionTimeMillisEstimate" : 0,
"works" : 6,
"advanced" : 4,
"needTime" : 1,
"needYield" : 0,
"saveState" : 0,
"restoreState" : 0,
"isEOF" : 1,
"transformBy" : {
"$recordId" : {
"$meta" : "recordId"
}
},
"inputStage" : {
"stage" : "COLLSCAN",
"nReturned" : 4,
"executionTimeMillisEstimate" : 0,
"works" : 6,
"advanced" : 4,
"needTime" : 1,
"needYield" : 0,
"saveState" : 0,
"restoreState" : 0,
"isEOF" : 1,
"direction" : "forward",
"docsExamined" : 4
}
}
},