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, in a previous PR. 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.

If you require this data, we recommend querying it from the REST API or making a backup of the database/these events before upgrading.
There are currently no plans to delete connection events from the new connection_logs table.

Future PRs:

• Write documentation for the endpoint / feature