Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-5470

View memorized query optimized plans

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Minor - P4
    • Resolution: Done
    • 2.0.4
    • 2.5.5
    • Querying
    • None
    • Fully Compatible
    • 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.

      Attachments

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-8871 Support admin hints per query pattern

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-12358 Add query plan history and logging

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              benety.goh@mongodb.com Benety Goh
              colinhowe Colin Howe
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: