[分析查询性能.如:查询耗费的时间/是否基于索引查询等]
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 }
```
