[SERVER-16301] Add index name to explain stats for query stages that use indexes Created: 24/Nov/14  Updated: 11/Jul/16  Resolved: 05/Dec/14

Status: Closed
Project: Core Server
Component/s: Diagnostics, Querying
Affects Version/s: None
Fix Version/s: 2.8.0-rc3

Type: Improvement Priority: Major - P3
Reporter: Jason Zucchetto Assignee: David Storch
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

With the new explain functionality, there is currently no way to determine the name of the index used (you would need to look at the keypattern field and getIndexes() for the collection).

A number of users rely on the index name for debugging queries (e.g. I created an index named "MY_INDEX", I want to ensure it is being used by a query).

There doesn't seem to be much overhead or downside to adding the index name to the IXSCAN stage, and preserves the functionality some users are expecting.



 Comments   
Comment by Githook User [ 05/Dec/14 ]

Author:

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

Message: SERVER-16301 add indexName to the explain output for index access stages
Branch: master
https://github.com/mongodb/mongo/commit/f6255b4bc16c6b1f3eee1bcadddb62648b33818b

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