[分析查询性能.如:查询耗费的时间/是否基于索引查询等]
stage:
COLLSCAN
全表扫描IXSCAN
索引扫描FETCH
根据索引去检索指定document
```jsondb.class.find({“sex”:”man”},{_id:false}).explain() { “queryPlanner” : { “plannerVersion” : 1, “namespace” : “Rainbow.class”, “indexFilterSet” : false, “parsedQuery” : { //查询语句’
"sex" : {
"$eq" : "man"
}
}, “winningPlan” : {
"stage" : "PROJECTION",
"transformBy" : {
"_id" : false
},
"inputStage" : {
"stage" : "FETCH",//COLLSCAN是全局扫描,未用上索引
"inputStage" : {
"stage" : "IXSCAN", //查看索引集合
"keyPattern" : {
"sex" : 1
},
"indexName" : "sexIndex", //可用索引的名字
"isMultiKey" : false,
"multiKeyPaths" : {
"sex" : [ ]
},
"isUnique" : false,
"isSparse" : false,
"isPartial" : false,
"indexVersion" : 2,
"direction" : "forward",
"indexBounds" : {
"sex" : [
"[\"man\", \"man\"]"
]
}
}
}
}, “rejectedPlans” : [ ] }, “serverInfo” : { “host” : “localhost”, “port” : 27017, “version” : “4.0.18”, “gitVersion” : “6883bdfb8b8cff32176b1fd176df04da9165fd67” }, “ok” : 1 }
```