~/logs/postgres.logs
- 1790937000002847 2026-10-02 10:30:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1790937000002915 delete from public.documents event body
- 1790937000002925 where metadata->>'type'='faq' event body
- 1790937000002934 and metadata->>'source_id' is not null event body
- 1790937000002942 and metadata->>'source_id' not in ( event body
- 1790937000002950 select id::text from public.faq_dermatologie event body
- 1790937000002958 union all select id::text from public.faq_allergologie event body
- 1790937000002987 ); event body
- 1790937000002993 event body
- 1790937000019628 2026-10-02 10:30:00.019 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790937900001990 2026-10-02 10:45:00.001 UTC [42] LOG: cron job 1 starting: event body
- 1790937900002028 delete from public.documents event body
- 1790937900002033 where metadata->>'type'='faq' event body
- 1790937900002038 and metadata->>'source_id' is not null event body
- 1790937900002042 and metadata->>'source_id' not in ( event body
- 1790937900002046 select id::text from public.faq_dermatologie event body
- 1790937900002050 union all select id::text from public.faq_allergologie event body
- 1790937900002054 ); event body
- 1790937900002057 event body
- 1790937900019629 2026-10-02 10:45:00.019 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790938800001909 2026-10-02 11:00:00.001 UTC [42] LOG: cron job 1 starting: event body
- 1790938800001958 delete from public.documents event body
- 1790938800001968 where metadata->>'type'='faq' event body
- 1790938800001976 and metadata->>'source_id' is not null event body
- 1790938800001984 and metadata->>'source_id' not in ( event body
- 1790938800001992 select id::text from public.faq_dermatologie event body
- 1790938800002000 union all select id::text from public.faq_allergologie event body
- 1790938800002008 ); event body
- 1790938800002016 event body
- 1790938800020130 2026-10-02 11:00:00.019 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790939700003260 2026-10-02 11:15:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1790939700003310 delete from public.documents event body
- 1790939700003319 where metadata->>'type'='faq' event body
- 1790939700003326 and metadata->>'source_id' is not null event body
- 1790939700003332 and metadata->>'source_id' not in ( event body
- 1790939700003339 select id::text from public.faq_dermatologie event body
- 1790939700003345 union all select id::text from public.faq_allergologie event body
- 1790939700003351 ); event body
- 1790939700003357 event body
- 1790939700013677 2026-10-02 11:15:00.013 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790940600002852 2026-10-02 11:30:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1790940600002895 delete from public.documents event body
- 1790940600002925 where metadata->>'type'='faq' event body
- 1790940600002932 and metadata->>'source_id' is not null event body
- 1790940600002937 and metadata->>'source_id' not in ( event body
- 1790940600002942 select id::text from public.faq_dermatologie event body
- 1790940600002947 union all select id::text from public.faq_allergologie event body
- 1790940600002952 ); event body
- 1790940600002957 event body
- 1790940600020246 2026-10-02 11:30:00.020 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790941500003212 2026-10-02 11:45:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1790941500003284 delete from public.documents event body
- 1790941500003298 where metadata->>'type'='faq' event body
- 1790941500003309 and metadata->>'source_id' is not null event body
- 1790941500003320 and metadata->>'source_id' not in ( event body
- 1790941500003332 select id::text from public.faq_dermatologie event body
- 1790941500003342 union all select id::text from public.faq_allergologie event body
- 1790941500003352 ); event body
- 1790941500003362 event body
- 1790941500015318 2026-10-02 11:45:00.015 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790942400002590 2026-10-02 12:00:00.002 UTC [42] LOG: cron job 1 starting: event body
- 1790942400002694 delete from public.documents event body
- 1790942400002711 where metadata->>'type'='faq' event body
- 1790942400002721 and metadata->>'source_id' is not null event body
- 1790942400002729 and metadata->>'source_id' not in ( event body
- 1790942400002737 select id::text from public.faq_dermatologie event body
- 1790942400002745 union all select id::text from public.faq_allergologie event body
- 1790942400002752 ); event body
- 1790942400002760 event body
- 1790942400022366 2026-10-02 12:00:00.022 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
- 1790943300002256 2026-10-02 12:15:00.001 UTC [42] LOG: cron job 1 starting: event body
- 1790943300002299 delete from public.documents event body
- 1790943300002309 where metadata->>'type'='faq' event body
- 1790943300002318 and metadata->>'source_id' is not null event body
- 1790943300002326 and metadata->>'source_id' not in ( event body
- 1790943300002334 select id::text from public.faq_dermatologie event body
- 1790943300002361 union all select id::text from public.faq_allergologie event body
- 1790943300002367 ); event body
- 1790943300002372 event body
- 1790943300018900 2026-10-02 12:15:00.018 UTC [42] LOG: cron job 1 COMMAND completed: DELETE 0 0 event body
random(tips): Search a date range (e.g. `t:2020-03-{01..05}T00:00:00`).