Purges old entries from the audit trail.

The function guarantees to keep data inserted at or after the specified timestamp and attempts to delete as many entries as possible inserted prior to the specified timestamp to reclaim as much storage space as possible. Note that there is no guarantee about how many entries will be deleted.

Available in a network database and requires the star$administrate role.


Name Optional Type Description
datetime$ Mandatory Timestamp The audit timestamp threshold.


SELECT purge_audit('2017-01-01'); -- reclaims space from audit entries inserted prior to Jan 2017


  • The star$audit view lists the current audit entries


Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk