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

View memorized query optimized plans

XMLWordPrintableJSON

    • Type: Icon: New Feature New Feature
    • Resolution: Done
    • Priority: Icon: Minor - P4 Minor - P4
    • 2.5.5
    • Affects Version/s: 2.0.4
    • Component/s: Querying
    • None
    • Fully Compatible
    • 0
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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.

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

              Created:
              Updated:
              Resolved: