[SERVER-16527] 2dsphere explain reports "works" for nscanned & nscannedObjects Created: 12/Dec/14  Updated: 25/Feb/15  Resolved: 23/Jan/15

Status: Closed
Project: Core Server
Component/s: Geo, Querying
Affects Version/s: 2.6.6
Fix Version/s: 2.6.8

Type: Bug Priority: Major - P3
Reporter: James Wahlin Assignee: David Storch
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Duplicate
is duplicated by SERVER-16402 $nearSphere with 2dsphere index (S2Ne... Closed
Related
Backwards Compatibility: Fully Compatible
Operating System: ALL
Participants:

 Description   

RE: https://github.com/mongodb/mongo/blob/r2.6.6/src/mongo/db/query/explain_plan.cpp#L266

When an explain is run on a $nearSphere query against a 2dsphere index we are incorrectly recording nscanned and nscannedObjects to be the "works" value rather than the actual # of index entries and documents evaluated.

This has been corrected for 2.8 as part of SERVER-9986 but not for 2.6. As SERVER-9986 is a broad ticket covering much more than this issue I am entering a separate ticket to address 2.6.



 Comments   
Comment by Githook User [ 23/Jan/15 ]

Author:

{u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}

Message: SERVER-16527 S2NearStage explain correctly reports nscanned, nscannedObjects, and isMultiKey
Branch: v2.6
https://github.com/mongodb/mongo/commit/37ea3acc57d117ea6414c108b9c888083dbf2144

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