第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

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

mongodb 3.0 中怎么顯示cursor和nscanned?

mongodb 3.0 中怎么顯示cursor和nscanned?

達令說 2019-04-10 20:48:07
如題這是我用explain顯示出來的數(shù)據(jù)>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條經(jīng)驗 獲得超7個贊

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

TA貢獻1796條經(jīng)驗 獲得超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
}
                            
查看完整回答
反對 回復(fù) 2019-04-10
  • 2 回答
  • 0 關(guān)注
  • 341 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動學習伙伴

公眾號

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號