[SERVER-4213] explain doesn't include index name on geo queries Created: 04/Nov/11  Updated: 11/Jul/16  Resolved: 18/Apr/14

Status: Closed
Project: Core Server
Component/s: Geo, Index Maintenance
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Minor - P4
Reporter: Spencer Brody (Inactive) Assignee: Unassigned
Resolution: Done Votes: 3
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

> db.system.indexes.find()
{ "v" : 1, "key" :

{ "_id" : 1 }

, "ns" : "test.system.users", "name" : "id" }
{ "v" : 1, "key" :

{ "_id" : 1 }

, "ns" : "test.foo", "name" : "id" }
{ "v" : 1, "key" :

{ "a" : 1, "b" : 1 }

, "ns" : "test.foo", "name" : "a_1_b_1" }
{ "v" : 1, "key" :

{ "b" : 1 }

, "ns" : "test.foo", "name" : "b_1" }
{ "v" : 1, "key" :

{ "l" : "2d", "a" : 1 }

, "ns" : "test.foo", "name" : "l__a_1" }
{ "v" : 1, "key" :

{ "l" : "2d", "b" : 2 }

, "ns" : "test.foo", "name" : "l__b_2" }

> db.foo.find({l:{$near:[55,55]},b:1}).explain()
{
"cursor" : "GeoSearchCursor",
"nscanned" : 0,
"nscannedObjects" : 0,
"n" : 0,
"millis" : 0,
"nYields" : 0,
"nChunkSkips" : 0,
"isMultiKey" : false,
"indexOnly" : false,
"indexBounds" : {

}
}

Note that it just says "GeoSearchCursor", without the name of the cursor. Unlike a query on a normal btree cursor, which includes the cursor name as well as the type:

> db.foo.find(

{a:1}

).explain()
{
"cursor" : "BtreeCursor a_1_b_1",
"nscanned" : 1,
"nscannedObjects" : 1,
"n" : 1,
"millis" : 0,
"nYields" : 0,
"nChunkSkips" : 0,
"isMultiKey" : false,
"indexOnly" : false,
"indexBounds" : {
"a" : [
[
1,
1
]
],
"b" : [
[

{ "$minElement" : 1 }

,

{ "$maxElement" : 1 }

]
]
}
}



 Comments   
Comment by Greg Studer [ 18/Apr/14 ]

This is a non-issue with other explain changes.

Attaching hari.khalsa@10gen.com for notification but no action needed.

Generated at Thu Feb 08 03:05:18 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.