[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: |
|
||||||||
| 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. |