[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:
Documented
is documented by DOCS-11025 Docs for SERVER-31610: Consider addin... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query 2017-11-13, Query 2017-12-04
Participants:
Case:

 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: SERVER-31610 Add timestamp to plan cache entries
Branch: master
https://github.com/mongodb/mongo/commit/bace2a3017ebd46ca96cc81f48f039b80e00d92a

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:
"timeOfCreation" : ISODate("2017-11-02T18:08:44.790Z")

Generated at Thu Feb 08 04:27:38 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.