image.png

Notices where this attachment appears

1. Embed this notice
   Phantasm (phnt@fluffytail.org)'s status on Thursday, 29-May-2025 05:59:47 JST Phantasm

   in reply to

   @mint @meow @nyanide @prettygood @waifu Here's a better one that only shows jobs that aren't completed

   select args->'params'->>'inbox',count(*), queue, worker, state from oban_jobs where worker = 'Pleroma.Workers.PublisherWorker' and args->'params'->>'inbox' != '' and state != 'completed' group by args->'params'->>'inbox',queue,worker,state having count(*) >= 5 order by count(*) desc;
   image.png