[SERVER-5470] View memorized query optimized plans Created: 01/Apr/12  Updated: 28/Oct/15  Resolved: 15/Jan/14

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

Type: New Feature Priority: Minor - P4
Reporter: Colin Howe Assignee: Benety Goh
Resolution: Done Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
Related
is related to SERVER-8871 Support admin hints per query pattern Closed
is related to SERVER-12358 Add query plan history and logging Closed
Backwards Compatibility: Fully Compatible
Participants:
Linked BF Score: 0

 Description   

The query optimizer decides on plans to use for certain queries, then memorizes that plan for the next 1,000 queries of that type (unless indexes change etc).

It would be really useful to have this information visible. It could be a good way of discovering what indices are being used for what queries. It could also then be used to find unused indices.



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

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 updated plan cache commands per updated spec
Branch: master
https://github.com/mongodb/mongo/commit/53a4b444ce35f5ac7bef14eccbcff60c0fee3081

Comment by Githook User [ 13/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 enable mongos plan cache commands in pass through mode.
Branch: master
https://github.com/mongodb/mongo/commit/e0c69afcf27e690ebb518b4a56e05d4d09e06510

Comment by Githook User [ 10/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 projection support for planCacheGenerateKey command. implemented query plan revision policy for write operations
Branch: master
https://github.com/mongodb/mongo/commit/cd77abcb81b466094d02b747a530b0762e0c82d4

Comment by Githook User [ 08/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 extended plan cache to hold all solutons from planning process
Branch: master
https://github.com/mongodb/mongo/commit/a548f5d0e555166bfef2e99ab52def93f3f1fa16

Comment by Githook User [ 08/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: Revert "SERVER-5470 extended plan cache to hold all solutons from planning process"
Branch: master
https://github.com/mongodb/mongo/commit/f87ff5cb5721eabffaae1ccc4a8dab8098d114fc

Comment by Githook User [ 08/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 extended plan cache to hold all solutons from planning process
Branch: master
https://github.com/mongodb/mongo/commit/0d818f66f1a2429ce65b19afd9b5e7b64076732b

Comment by Githook User [ 03/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 plan cache should be retrieved from database not context
Branch: master
https://github.com/mongodb/mongo/commit/04221630900335fc6ee0d9922edae9d29f02d66d

Comment by Githook User [ 02/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 register plan cache commands in a static initializer
Branch: master
https://github.com/mongodb/mongo/commit/94aa072feddc099ccd7579a5b41d8d567b86b194

Comment by Githook User [ 01/Jan/14 ]

Author:

{u'username': u'benety', u'name': u'Benety Goh', u'email': u'benety@mongodb.com'}

Message: SERVER-5470 added plan cache DB commands
Branch: master
https://github.com/mongodb/mongo/commit/de8af0f35153b718307f5a96cd5be255a90e0e8e

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