test@local(2.6.0-rc0) > db.multi.find({m:99999}).explain()
{
"cursor" : "BtreeCursor m_1",
"isMultiKey" : true,
"n" : 0,
"nscannedObjects" : 0,
"nscanned" : 0,
"nscannedObjectsAllPlans" : 0,
"nscannedAllPlans" : 0,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"indexBounds" : {
"m" : [
[
99999,
99999
]
]
},
"server" : "asyasmacbook.local:27017",
"filterSet" : false
}
test@local(2.6.0-rc0) > db.multi.find({m:99999},{_id:0,m:1}).explain()
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 102,
"nscanned" : 102,
"nscannedObjectsAllPlans" : 105,
"nscannedAllPlans" : 105,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"server" : "asyasmacbook.local:27017",
"filterSet" : false
}
test@local(2.6.0-rc0) > db.multi.find({m:99999},{_id:0,m:1}).explain(true)
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 102,
"nscanned" : 102,
"nscannedObjectsAllPlans" : 105,
"nscannedAllPlans" : 105,
"scanAndOrder" : false,
"indexOnly" : false,
"nYields" : 0,
"nChunkSkips" : 0,
"millis" : 0,
"allPlans" : [
{
"cursor" : "BasicCursor",
"isMultiKey" : false,
"n" : 0,
"nscannedObjects" : 102,
"nscanned" : 102,
"scanAndOrder" : false,
"indexOnly" : false,
"nChunkSkips" : 0
},
{
"cursor" : "BtreeCursor m_1",
"isMultiKey" : true,
"n" : 3,
"nscannedObjects" : 3,
"nscanned" : 3,
"scanAndOrder" : false,
"indexOnly" : false,
"nChunkSkips" : 0,
"indexBounds" : {
"m" : [
[
1,
1
]
]
}
}
],
"server" : "asyasmacbook.local:27017",
"filterSet" : false,
"stats" : {
"type" : "PROJECTION",
"works" : 104,
"yields" : 0,
"unyields" : 0,
"invalidates" : 0,
"advanced" : 0,
"needTime" : 0,
"needFetch" : 0,
"isEOF" : 1,
"children" : [
{
"type" : "COLLSCAN",
"works" : 104,
"yields" : 0,
"unyields" : 0,
"invalidates" : 0,
"advanced" : 0,
"needTime" : 103,
"needFetch" : 0,
"isEOF" : 1,
"docsTested" : 102,
"children" : [ ]
}
]
}
}