亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

mongodb 3.0 中怎么顯示cursor和nscanned?

mongodb 3.0 中怎么顯示cursor和nscanned?

達令說 2019-04-10 20:48:07
如題這是我用explain顯示出來的數據>db.users.explain("allPlansExecution").find({username:'user101'}){"queryPlanner":{"plannerVersion":1,"namespace":"test.users","indexFilterSet":false,"parsedQuery":{"username":{"$eq":"user101"}},"winningPlan":{"stage":"FETCH","inputStage":{"stage":"IXSCAN","keyPattern":{"username":1},"indexName":"username_1","isMultiKey":false,"direction":"forward","indexBounds":{"username":["[\"user101\",\"user101\"]"]}}},"rejectedPlans":[]},"executionStats":{"executionSuccess":true,"nReturned":1,"executionTimeMillis":0,"totalKeysExamined":1,"totalDocsExamined":1,"executionStages":{"stage":"FETCH","nReturned":1,"executionTimeMillisEstimate":0,"works":2,"advanced":1,"needTime":0,"needFetch":0,"saveState":0,"restoreState":0,"isEOF":1,"invalidates":0,"docsExamined":1,"alreadyHasObj":0,"inputStage":{"stage":"IXSCAN","nReturned":1,"executionTimeMillisEstimate":0,"works":2,"advanced":1,"needTime":0,"needFetch":0,"saveState":0,"restoreState":0,"isEOF":1,"invalidates":0,"keyPattern":{"username":1},"indexName":"username_1","isMultiKey":false,"direction":"forward","indexBounds":{"username":["[\"user101\",\"user101\"]"]},"keysExamined":1,"dupsTested":0,"dupsDropped":0,"seenInvalidated":0,"matchTested":0}},"allPlansExecution":[]},"serverInfo":{"host":"mongo2","port":27017,"version":"3.0.0","gitVersion":"a841fd6394365954886924a35076691b4d149168"},"ok":1}
查看完整描述

2 回答

?
嚕嚕噠

TA貢獻1784條經驗 獲得超7個贊

剛剛查了下文檔,怪自己沒仔細看結果。。
queryPlanner.winningPlan.inputStage.stage列顯示查詢策略
-IXSCAN表示使用Index查詢
-COLLSCAN表示使用列查詢,也就是一個一個對比過去
cursor中的索引名稱移動到了queryPlanner.winningPlan.inputStage.indexName
3.0中使用executionStats.totalDocsExamined來顯示總共需要檢查的文檔數,用以取而代之nscanned。
                            
查看完整回答
反對 回復 2019-04-10
?
SMILET

TA貢獻1796條經驗 獲得超4個贊

>db.person.find({age:{$lt:20}}).explain("executionStats")
"executionStats":{
"executionSuccess":true,
"nReturned":20,
"executionTimeMillis":567,
"totalKeysExamined":0,
"totalDocsExamined":1000000,
"executionStages":{
"stage":"COLLSCAN",
"filter":{
"age":{
"$lt":20
}
},
"nReturned":20,
"executionTimeMillisEstimate":520,
"works":1000002,
"advanced":20,
"needTime":999981,
"needFetch":0,
"saveState":7812,
"restoreState":7812,
"isEOF":1,
"invalidates":0,
"direction":"forward",
"docsExamined":1000000
}
                            
查看完整回答
反對 回復 2019-04-10
  • 2 回答
  • 0 關注
  • 346 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號