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

Log when and why a query shape begins to use a different plan

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Diagnostics, Querying
    • None

      Currently, if a plan occasionally flips flops to a less optimal query (or a bug occurs) it can be extremely challenging (or impossible), to catch the plan cache in the bad state.

      Setting the QLOG on for all queries isn't reasonable as that generates too much output for high use systems.

      Having an option to only output the QLOG if the plan changes so that the reason for change can be recorded automatically enable the quick diagnosis of these cases.

            Assignee:
            Unassigned Unassigned
            Reporter:
            charlie.page@10gen.com Charlie Page
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: