Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://fluffytail.org/objects/9ff96ec7-a304-4157-9206-6e53adc22da4">Phantasm (phnt@fluffytail.org)'s status on Thursday, 29-May-2025 05:59:47 JST</a><a href="https://fluffytail.org/users/phnt" title="phnt@fluffytail.org"><img src="https://gnusocial.jp/avatar/158739-48-20230808204705.webp" width="48" height="48" alt="Phantasm" style="position: absolute; left: 0; top: 0;">Phantasm</a><div><a href="https://fluffytail.org/objects/76f7ba17-a5b6-4cf5-88c0-1af23fb35aad" rel="in-reply-to">in reply to</a><ul><li><li><a href="https://gnusocial.jp/user/148935" title="prettygood@socially.drinkingatmy.computer">prettygood</a></li><li><a href="https://gnusocial.jp/user/158739" title="phnt@fluffytail.org">Phantasm</a></li><li><a href="https://gnusocial.jp/user/237558" title="waifu@mai.waifuism.life">waifu</a></li><li><a href="https://gnusocial.jp/user/284087" title="nyanide@lab.nyanide.com">nyanide :nyancat_rainbow::nyancat_body::nyancat_face:</a></li><li><a href="https://gnusocial.jp/user/347112" title="meow@deerfan.club">meow</a></li></ul></div></section><article><p><a href="https://ryona.agency/users/mint">@mint</a> <a href="https://deerfan.club/@meow">@meow</a> <a href="https://lab.nyanide.com/users/nyanide">@nyanide</a> <a href="https://socially.drinkingatmy.computer/users/prettygood">@prettygood</a> <a href="https://mai.waifuism.life/@waifu">@waifu</a> Here's a better one that only shows jobs that aren't completed</p>select args-&gt;'params'-&gt;&gt;'inbox',count(*), queue, worker, state from oban_jobs where worker = 'Pleroma.Workers.PublisherWorker' and args-&gt;'params'-&gt;&gt;'inbox' != '' and state != 'completed' group by args-&gt;'params'-&gt;&gt;'inbox',queue,worker,state having count(*) &gt;= 5 order by count(*) desc;
<br><a href="https://upload.fluffytail.org/media/3e/91/57/3e9157101fe84572c761818f89dbfc37be19e5bdaf410ff357b84a188783b3ad.png?name=image.png">image.png</a></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/5116709#notice-10036329">In conversation</a><time datetime="2025-05-29T05:59:47+09:00" title="Thursday, 29-May-2025 05:59:47 JST">about 23 days ago</time> <span>from <span><a href="https://fluffytail.org/objects/9ff96ec7-a304-4157-9206-6e53adc22da4" rel="external" title="Sent from fluffytail.org via ActivityPub">fluffytail.org</a></span></span><a href="https://fluffytail.org/objects/9ff96ec7-a304-4157-9206-6e53adc22da4">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/4695313">image.png</a></label><br><a href="https://upload.fluffytail.org/media/3e/91/57/3e9157101fe84572c761818f89dbfc37be19e5bdaf410ff357b84a188783b3ad.png?name=image.png" rel="external">https://upload.fluffytail.org/media/3e/91/57/3e9157101fe84572c761818f89dbfc37be19e5bdaf410ff357b84a188783b3ad.png?name=image.png</a></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
Phantasm (phnt@fluffytail.org)'s status on Thursday, 29-May-2025 05:59:47 JSTPhantasm
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
In conversationabout 23 days ago from fluffytail.orgpermalink
Attachments
1. image.png
  https://upload.fluffytail.org/media/3e/91/57/3e9157101fe84572c761818f89dbfc37be19e5bdaf410ff357b84a188783b3ad.png?name=image.png

Public

Embed Notice

HTML Code

Corresponding Notice