Breaking change (changelog note):

With new connection events appearing in the Connection Log, connection events older than 90 days will now be deleted from the Audit Log. If you require this legacy data, we recommend querying it from the REST API or making a backup of the database/these events before upgrading your Coder deployment. Please see the PR for details on what exactly will be deleted.
Of note is that there are currently no plans to delete connection events from the Connection Log.

Context

This is the fifth PR for moving connection events out of the audit log.

In previous PRs:

• New connection logs have been routed to the connection_logs table. They will not appear in the audit log.
• These new connection logs are served from the new /api/v2/connectionlog endpoint.

In this PR:

• We'll now clean existing connection events out of the audit log, if they are older than 90 days, We do this in batches of 1000, every 10 minutes.

The criteria for deletion is simple:

WHERE
(
     action = 'connect'
     OR action = 'disconnect'
     OR action = 'open'
     OR action = 'close'
)
AND "time" < @before_time::timestamp with time zone

where @before_time is currently configured to 90 days in the past.

Future PRs:

• Write documentation for the endpoint / feature