[SERVER-11889] Add new plan stats to explain output Created: 27/Nov/13  Updated: 28/Oct/15  Resolved: 13/Jan/14

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.5.4
Fix Version/s: 2.5.5

Type: Improvement Priority: Major - P3
Reporter: Alvin Richards (Inactive) Assignee: hari.khalsa@10gen.com
Resolution: Done Votes: 0
Labels: 26qa, explain, nqf, query_triage
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-10565 Re-implement explain() for new execut... Closed
Participants:

 Description   

Problem:
The PlanStage class provides a getStats() method to allow the derived classes (e.g. index_scan, collection_scan etc.) to collect statistics about their specific execution.

The various runners (SingleSolution, CachedRunner etc.) call getStats() in the getExplainPlan implementation. However, the details collection by each concrete implementation are not projected in the explain plan.

This could provide core development/debug information as well as help customer support scenarios.

Solution:
Enable the dumping out of the getStats() output into the explain plan.

To view the stats from the shell, use db.col.find().explain(true)

Workaround:
None.



 Comments   
Comment by Githook User [ 21/Jan/14 ]

Author:

{u'username': u'monkey101', u'name': u'Dan Pasette', u'email': u'dan@10gen.com'}

Message: SERVER-11889 only show stats field in shell with verbose explain
Branch: master
https://github.com/mongodb/mongo/commit/6d460f440dbe30fae04663771db8c9c9bbe79779

Comment by Githook User [ 13/Jan/14 ]

Author:

{u'username': u'hkhalsa', u'name': u'Hari Khalsa', u'email': u'hkhalsa@10gen.com'}

Message: SERVER-11889 add full stats tree to explain, cobble something together for ixisect explain
Branch: master
https://github.com/mongodb/mongo/commit/ff9150f79740233c21c658cd368a3255bba0d400

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