Details

    • Type: New Feature New Feature
    • Status: Closed Closed
    • Priority: Minor - P4 Minor - P4
    • Resolution: Fixed
    • Affects Version/s: 2.0.4
    • Fix Version/s: 2.5.5
    • Component/s: Querying
    • Labels:
      None
    • Backport:
      No
    • Backward Breaking:
      No
    • # Replies:
      9
    • Last comment by Customer:
      true
    • Documentation changes needed?:
      Yes
    • Driver changes needed?:
      Driver changes needed

      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.

        Issue Links

          Activity

          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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
          Hide
          Githook User
          added a comment -

          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

          Show
          Githook User
          added a comment - 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

            People

            • Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since reply:
                13 weeks, 4 days ago
                Date of 1st Reply: