Details
-
Bug
-
Resolution: Duplicate
-
Major - P3
-
None
-
2.5.5
-
None
-
Fully Compatible
-
ALL
Description
There is an index on city and on state:
geo@local(2.5.5) > db.zips.find({city:"HAZARD"}).explain()
|
{
|
"cursor" : "BtreeCursor city_1",
|
"isMultiKey" : false,
|
"n" : 2,
|
"nscannedObjects" : 2,
|
"nscanned" : 2,
|
"nscannedObjectsAllPlans" : 2,
|
"nscannedAllPlans" : 2,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 0,
|
"nChunkSkips" : 0,
|
"millis" : 0,
|
"indexBounds" : {
|
"city" : [
|
[
|
"HAZARD",
|
"HAZARD"
|
]
|
]
|
},
|
"server" : "asyasmacbook.local:27017"
|
}
|
geo@local(2.5.5) > db.zips.find({state:"CA"}).explain()
|
{
|
"cursor" : "BtreeCursor state_1",
|
"isMultiKey" : false,
|
"n" : 1523,
|
"nscannedObjects" : 1523,
|
"nscanned" : 1523,
|
"nscannedObjectsAllPlans" : 1523,
|
"nscannedAllPlans" : 1523,
|
"scanAndOrder" : false,
|
"indexOnly" : false,
|
"nYields" : 11,
|
"nChunkSkips" : 0,
|
"millis" : 3,
|
"indexBounds" : {
|
"state" : [
|
[
|
"CA",
|
"CA"
|
]
|
]
|
},
|
"server" : "asyasmacbook.local:27017"
|
}
|
geo@local(2.5.5) > db.zips.find({city:"HAZARD",state:"CA"}).explain()
|
{
|
"cursor" : "Complex Plan",
|
"n" : 1,
|
"nscannedObjects" : 0,
|
"nscanned" : 1525,
|
"nscannedObjectsAllPlans" : 0,
|
"nscannedAllPlans" : 1525,
|
"nYields" : 11,
|
"nChunkSkips" : 0,
|
"millis" : 1,
|
"server" : "asyasmacbook.local:27017"
|
}
|
geo@local(2.5.5) >
|
Attachments
Issue Links
- duplicates
-
SERVER-10448 Revamp explain() formatting
-
- Closed
-