Skip to content

Instantly share code, notes, and snippets.

@stompro

stompro/audit table cleanup.sql

Created July 13, 2016 15:50
Show Gist options
  • Save stompro/3c1404e4169d8e9cf57664e88ece2f6e to your computer and use it in GitHub Desktop.
Save stompro/3c1404e4169d8e9cf57664e88ece2f6e to your computer and use it in GitHub Desktop.
Download ZIP
Audit Table Cleanup Evergreen
Raw
audit table cleanup.sql
Need to delete old false records from audit tables.
-- Count of bib audit records before a certain date.
select count(audit_id) from auditor.biblio_record_entry_lifecycle where audit_time<'2015-10-17'::timestamp;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment