[SERVER-31610] Consider adding a timestamp to plan cache entries Created: 17/Oct/17 Updated: 30/Oct/23 Resolved: 14/Nov/17 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 3.6.0-rc4 |
| Type: | New Feature | Priority: | Major - P3 |
| Reporter: | Chris Harris | Assignee: | Janna Golden |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||
| Sprint: | Query 2017-11-13, Query 2017-12-04 | ||||||||
| Participants: | |||||||||
| Case: | (copied to CRM) | ||||||||
| Description |
|
At present entries in the query plan cache do not have metadata about when they were generated. It would be helpful to have this to, for example, determine how recently the entry changed. |
| Comments |
| Comment by Githook User [ 13/Nov/17 ] |
|
Author: {'name': 'jannaerin', 'username': 'jannaerin', 'email': 'golden.janna@gmail.com'}Message: |
| Comment by David Storch [ 02/Nov/17 ] |
|
LGTM. Other possible names are createdAt or creationTime, though no strong preference from my end. |
| Comment by Janna Golden [ 02/Nov/17 ] |
|
christopher.harris I plan to add a field "timeOfCreation" to the output of planCacheListPlans, will this be helpful for you? The added field would look like: |