~/logs/postgres.logs
- 1784286900003640 and metadata->>'source_id' not in ( event body
- 1784313900003279 and metadata->>'source_id' not in ( event body
- 1784330100002668 and metadata->>'source_id' is not null event body
- 1784351700003869 delete from public.documents event body
- 1784368800002656 event body
- 1784390400017633 2026-07-18 16:00:00.017 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1784394900002558 where metadata->>'type'='faq' event body
- 1784401200003019 and metadata->>'source_id' not in ( event body
- 1784417400002965 union all select id::text from public.faq_allergologie event body
- 1784443500002821 select id::text from public.faq_dermatologie event body
- 1784465100002961 where metadata->>'type'='faq' event body
- 1784465100002994 union all select id::text from public.faq_allergologie event body
- 1784529000003071 where metadata->>'type'='faq' event body
- 1784532600002889 where metadata->>'type'='faq' event body
- 1784538000003446 and metadata->>'source_id' not in ( event body
- 1784572200002911 where metadata->>'type'='faq' event body
- 1784574900004916 event body
- 1784579400002317 select id::text from public.faq_dermatologie event body
- 1784580300003128 event body
- 1784604600003013 and metadata->>'source_id' not in ( event body
- 1784604600017375 2026-07-21 03:30:00.017 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1784610900002476 2026-07-21 05:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1784616300003987 and metadata->>'source_id' is not null event body
- 1784636100002325 delete from public.documents event body
- 1784650500002749 and metadata->>'source_id' is not null event body
- 1784664900003475 and metadata->>'source_id' is not null event body
- 1784665800003099 select id::text from public.faq_dermatologie event body
- 1784713500003318 event body
- 1784746800022464 2026-07-22 19:00:00.022 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1784829600002024 2026-07-23 18:00:00.001 UTC [42] LOG: cron job 1 starting: event body
- 1784881800002759 select id::text from public.faq_dermatologie event body
- 1784891700002487 where metadata->>'type'='faq' event body
- 1784907900002762 2026-07-24 15:45:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1784907900002829 delete from public.documents event body
- 1784917800002665 event body
- 1784928600002889 ); event body
- 1784959200003128 union all select id::text from public.faq_allergologie event body
- 1784982600003269 select id::text from public.faq_dermatologie event body
- 1785024000003145 ); event body
- 1785032100002864 event body
- 1785040200003320 delete from public.documents event body
- 1785093300003135 and metadata->>'source_id' is not null event body
- 1785132000002906 and metadata->>'source_id' is not null event body
- 1785160800002982 delete from public.documents event body
- 1785208500002728 and metadata->>'source_id' not in ( event body
- 1785217500002956 ); event body
- 1785249000003528 ); event body
- 1785297600002763 select id::text from public.faq_dermatologie event body
- 1785323700003072 2026-07-29 11:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1785329100004403 ); event body
- 1785330000002453 where metadata->>'type'='faq' event body
- 1785373200003611 and metadata->>'source_id' is not null event body
- 1785384000003495 ); event body
- 1785394800002962 event body
- 1785398400003201 2026-07-30 08:00:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1785415500002921 2026-07-30 12:45:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1785434400002792 delete from public.documents event body
- 1785492900002831 select id::text from public.faq_dermatologie event body
- 1785547800003169 select id::text from public.faq_dermatologie event body
- 1785574800003205 and metadata->>'source_id' not in ( event body
- 1785598200003339 union all select id::text from public.faq_allergologie event body
- 1785599100003192 delete from public.documents event body
- 1785630600002755 and metadata->>'source_id' not in ( event body
- 1785687300002673 delete from public.documents event body
- 1785738600002652 select id::text from public.faq_dermatologie event body
- 1785833100003101 2026-08-04 08:45:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1785838500002984 and metadata->>'source_id' is not null event body
- 1785861900002815 where metadata->>'type'='faq' event body
- 1785877200003879 and metadata->>'source_id' is not null event body
- 1785879900002615 delete from public.documents event body
- 1785934800002895 select id::text from public.faq_dermatologie event body
- 1785938400021559 2026-08-05 14:00:00.021 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1785942900003538 select id::text from public.faq_dermatologie event body
- 1785976200003637 select id::text from public.faq_dermatologie event body
- 1786009500002837 delete from public.documents event body
- 1786030200002854 event body
- 1786032000002359 union all select id::text from public.faq_allergologie event body
- 1786043700003488 event body
- 1786095000002583 delete from public.documents event body
- 1786148100002838 2026-08-08 00:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1786151700002871 2026-08-08 01:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1786165200002943 and metadata->>'source_id' is not null event body
- 1786171500002869 delete from public.documents event body
- 1786176000003196 union all select id::text from public.faq_allergologie event body
- 1786183200003637 select id::text from public.faq_dermatologie event body
- 1786225500003175 event body
- 1786228200003067 union all select id::text from public.faq_allergologie event body
- 1786231800002855 2026-08-08 23:30:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1786237200003217 delete from public.documents event body
- 1786242600003478 delete from public.documents event body
- 1786250700003470 where metadata->>'type'='faq' event body
- 1786266000003223 2026-08-09 09:00:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1786268700002911 2026-08-09 09:45:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1786274100001991 event body
- 1786315500003121 ); event body
- 1786364100002989 and metadata->>'source_id' not in ( event body
- 1787108400002722 delete from public.documents event body
- 1787108400002767 select id::text from public.faq_dermatologie event body
- 1787130900003020 2026-08-19 09:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1787131800004105 select id::text from public.faq_dermatologie event body
random(tips): Search a date range (e.g. `t:2020-03-{01..05}T00:00:00`).