src/sql/accessLogPurgeOld.sql


1
2
3
4
5
6
7
8
9
10
11

WITH scope AS (
	SELECT id
	FROM access_log
	ORDER BY id
	LIMIT ?
), scoperange AS (
	SELECT min(id) minid, max(id) maxid
	FROM scope)
DELETE FROM access_log USING scoperange
WHERE request_time < CURRENT_DATE - ?::interval
	AND access_log.id BETWEEN scoperange.minid AND scoperange.maxid