diff options
Diffstat (limited to 'src/sql/accessLogPurgeOld.sql')
| -rw-r--r-- | src/sql/accessLogPurgeOld.sql | 19 |
1 files changed, 13 insertions, 6 deletions
diff --git a/src/sql/accessLogPurgeOld.sql b/src/sql/accessLogPurgeOld.sql index 8379018..18ec775 100644 --- a/src/sql/accessLogPurgeOld.sql +++ b/src/sql/accessLogPurgeOld.sql @@ -1,11 +1,18 @@ WITH scope AS ( - SELECT id - FROM access_log - ORDER BY id + SELECT + id + FROM + access_log + ORDER BY + id LIMIT ? -), scoperange AS ( - SELECT min(id) minid, max(id) maxid - FROM scope) +), +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 |