insert into new_task(id, type, arguments, next_run, current_interval, status, policy,
  retries_left, priority)
select id, type, arguments, next_run, current_interval, status, policy,
  retries_left, priority
from task
where (
    policy='recurring' and (type = 'load-nixguix' or
                            type like 'list-%' or
                            type like 'index-%')
  ) or (
    policy = 'oneshot' and next_run > now() - interval '2 months'
  );
INSERT 0 2929609
Time: 742707.838 ms (12:22.708)
insert into new_task_run
select id, task, backend_id, scheduled, started, ended, metadata, status
from task_run where task in (
  select distinct id from new_task
);
INSERT 0 613863
Time: 242376.477 ms (04:02.376)

select last_value from task_run_id_seq;
 last_value
------------
 1424372613
(1 row)

Time: 0.206 ms
alter table task rename to archive_task;
^CCancel request sent
psql:33.sql:64: ERROR:  canceling statement due to user request
Time: 3397101.882 ms (56:37.102)