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

Add field to explain to indicate if winning and rejected plans are cached

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • QO 2023-11-27, QO 2023-12-11

      To aid in support cases and allow explain to convey information about the cached plan (since usually it is ignored), we should add an "isCached" field to all plans listed in explain. This will be a boolean to indicate whether the plan matches the cached plan.

      For support cases where a bad plan is cached and the user runs explain and sees a different plan reported, the issue will be more obvious. We can also add a top level field "doesWinningPlanMatchCached" to surface this even higher.

            Assignee:
            matt.boros@mongodb.com Matt Boros
            Reporter:
            matt.boros@mongodb.com Matt Boros
            Votes:
            0 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: