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

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 7.3.0-rc0
    • None
    • None
    • None
    • Fully Compatible
    • QO 2023-11-27, QO 2023-12-11

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: