[SERVER-4504] aggregation: need an explain facility Created: 15/Dec/11  Updated: 27/Oct/15  Resolved: 20/Sep/13

Status: Closed
Project: Core Server
Component/s: Aggregation Framework
Affects Version/s: None
Fix Version/s: 2.5.3

Type: New Feature Priority: Major - P3
Reporter: Dan Pasette Assignee: Mathias Stearn
Resolution: Fixed Votes: 51
Labels: None

Issue Links:
Depends
depends on SERVER-6140 sharded aggregation explain failure Closed
is depended on by DOCS-215 add documentation for the explain opt... Closed
is depended on by JAVA-954 Add helper for explain on an aggregat... Closed
Related
is related to SERVER-447 new aggregation framework Closed
is related to SERVER-5090 aggregation: use covered index Closed
Backwards Compatibility: Fully Compatible
Participants:

 Description   

Right now there's no way to tell what underlying query will be used for an aggregation pipeline; knowing that would help with performance issues. As well as that, as we apply more optimizations to pipeline execution, we'll want to be able to see the original pipeline specification as well as what it has been transformed to by the optimizer.



 Comments   
Comment by auto (Inactive) [ 21/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504 aggregation explain implementation
Branch: master
https://github.com/mongodb/mongo/commit/c13ff660e615ef76f6f4dbc8c62d24c6b4ae54cc

Comment by auto (Inactive) [ 21/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504 minor changes from code review
Branch: master
https://github.com/mongodb/mongo/commit/54f86fa31d31b90bfa9d086520821e402cc5589a

Comment by auto (Inactive) [ 21/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504 minor changes from code review
Branch: master
https://github.com/mongodb/mongo/commit/ef05c4ef68afe4b9db9e5604e017235e79a3fab1

Comment by auto (Inactive) [ 21/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504 use
Branch: master
https://github.com/mongodb/mongo/commit/51b19f8296d62c2f518bd9edae2a5056d51acd8c

Comment by auto (Inactive) [ 31/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504 big explain: fix recursive lock issue
Branch: master
https://github.com/mongodb/mongo/commit/fcf121792af0ea41f31e3a17b90d62687d065c5b

Comment by auto (Inactive) [ 31/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504; minor changes from Mathias' code review
Branch: master
https://github.com/mongodb/mongo/commit/d0790729c406ee25e7bb77f5f594e573f654d2b3

Comment by auto (Inactive) [ 31/May/12 ]

Author:

{u'login': u'cwestin', u'name': u'U-tellus\\cwestin', u'email': u'cwestin@10gen.com'}

Message: SERVER-4504; enhanced a comment as requested by Mathias
Branch: master
https://github.com/mongodb/mongo/commit/9eb4a521d3f17b1707c9ad3b7261031673f4e4a1

Comment by auto (Inactive) [ 20/Sep/13 ]

Author:

{u'username': u'RedBeard0531', u'name': u'Mathias Stearn', u'email': u'mathias@10gen.com'}

Message: SERVER-4504 explain for aggregation

This is just the infrastucture change. Each DocumentSource will need to
have it's serialize()/serializeToArray() implementation examined and
improved.

Related tickets:
SERVER-6140 A specific failure in the old impl of explain.
Branch: master
https://github.com/mongodb/mongo/commit/755e7956642c01d2ba6ae7cf184b0f1a8aa0eab1

Comment by auto (Inactive) [ 20/Sep/13 ]

Author:

{u'username': u'RedBeard0531', u'name': u'Mathias Stearn', u'email': u'mathias@10gen.com'}

Message: SERVER-4504 Improve DocumentSourceCursor explain

Running an explain on a new query through DBDirectClient is just wrong
here. It needs to describe the actual cursor created by agg rather than
the cursor that would be used in a similar find.
Branch: master
https://github.com/mongodb/mongo/commit/7bf16104e2d7a2d0e9ee653606eaa83947bdccf1

Generated at Sat Sep 23 15:05:30 UTC 2017 using JIRA 7.2.10#72012-sha1:2651463a07e52d81c0fcf01da710ca333fcb42bc.