[SERVER-77859] Add parameter is explain with 'executionStats' output to indicate if plan cache is used Created: 07/Jun/23  Updated: 27/Oct/23  Resolved: 07/Jun/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Arun Banala Assignee: Backlog - Query Execution
Resolution: Gone away Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-16895 Users should be able to request that ... Open
Assigned Teams:
Query Execution
Participants:

 Description   

The current explain output does not indicate whether plan cache was used for the given query. There is no easy way to diagnose if the query went through planning. Adding a parameter to the explain output will make this easier



 Comments   
Comment by David Storch [ 07/Jun/23 ]

The current status is that explain never reads from the plan cache nor writes the resulting plan to the plan cache. We have an old ticket about allowing users to request that explain use the plan cache: SERVER-16895.

Generated at Thu Feb 08 06:36:48 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.