For the complete documentation index, see llms.txt. This page is also available as Markdown.

Setup

CREATE EXTENSION pg_cron;
SELECT cron.schedule_in_database('remove-completed-process-instances', '0 4 * * 0', $$DELETE FROM "public"."process_instance" WHERE ("state" = 'COMPLETED')$$, 'postgres');
DELETE FROM "public"."process_instance" WHERE ("state" = 'COMPLETED')

Last updated