[SERVER-44388] Add "Date created" field to db.collection.stats() output Created: 04/Nov/19  Updated: 06/Dec/22  Resolved: 20/Jul/20

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

Type: Improvement Priority: Minor - P4
Reporter: Nic Cottrell Assignee: Backlog - Storage Execution Team
Resolution: Won't Do Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Assigned Teams:
Storage Execution
Participants:

 Description   

It would be very useful to see the date/timestamp when a collection was created in the output of db.collection.stats().

Also displaying the "last accessed" could be useful, but I imagine that the overhead of keeping such a value updated means that it is probably not available in the underlying WT metadata.

Use case: to be able to quickly see if a given collection is recent and is still actively being used, much like $indexStats



 Comments   
Comment by Connie Chen [ 20/Jul/20 ]

We feel that the solution for this problem would require information that we do not have in the catalog. This would result in a lot of work related to replication and backup that we currently do not think is worth it.

Comment by Carl Champain (Inactive) [ 04/Nov/19 ]

Hi nicholas.cottrell

Passing this ticket along to the Storage Engines team.

Generated at Thu Feb 08 05:05:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.