-
Type: Bug
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: 2.5.5
-
Component/s: Querying
-
None
-
Fully Compatible
-
ALL
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) >
- duplicates
-
SERVER-10448 Revamp explain() formatting
- Closed