-
Task
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
-
5
-
False
-
-
True
-
-
Context
We need to capture statistics on how our database records change over the course of a month to drive implementation details for our dataverse integration.
Goal
Determine how many inserts, updates, and deletes occur per table so we can target which tables need special handling.
Current WIP (linked github)
Using Floorist to dump query results to S3 buckets nightly. We can then analyze the data (potentially using Claude, Gemini, or other analysis tools).
Investigation Notes
- Looked into AWS RDS insights/CloudWatch for this data but didn't find what we needed
- May be worth investigating AWS metrics again
Acceptance Criteria
- Tooling or documentation to answer: "How many inserts/updates/deletes have happened for table X over a month?"
- Per-table statistics available for analysis