Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://ryona.agency/objects/f3028985-d096-4604-8240-9a32194ddbd9"> (mint@ryona.agency)'s status on Friday, 02-Aug-2024 07:23:19 JST</a><a href="https://ryona.agency/users/mint" title="mint@ryona.agency"><img src="https://gnusocial.jp/avatar/1002-48-20220724171046.webp" width="48" height="48" alt="" style="position: absolute; left: 0; top: 0;"></a><div><a href="https://lab.nyanide.com/objects/93ca2d76-8cc7-45b4-929a-252d249a740d" rel="in-reply-to">in reply to</a><ul><li></ul></div></section><article><a href="https://lab.nyanide.com/users/kirby">@kirby</a> Frozen federation aside, did you by any chance had cleanup_attachments enabled? For years it did literally nothing, but after some recent commit it apparently started executing some heavy query.<br><a href="https://git.pleroma.social/pleroma/pleroma/-/issues/1540" rel="nofollow noreferrer">https://git.pleroma.social/pleroma/pleroma/-/issues/1540</a></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/3461922#notice-6805114">In conversation</a><time datetime="2024-08-02T07:23:19+09:00" title="Friday, 02-Aug-2024 07:23:19 JST">about 7 months ago</time> <span>from <span><a href="https://ryona.agency/objects/f3028985-d096-4604-8240-9a32194ddbd9" rel="external" title="Sent from ryona.agency via ActivityPub">ryona.agency</a></span></span><a href="https://ryona.agency/objects/f3028985-d096-4604-8240-9a32194ddbd9">permalink</a><h4>Attachments</h4><ol><li><article><header><div>Domain not in remote thumbnail source whitelist: git.pleroma.social</div><h5><a href="https://git.pleroma.social/pleroma/pleroma/-/issues/1540">Some query keeps hammering my DB (#1540) · Issues · Pleroma / pleroma · GitLab</a></h5><div></div></header><div>This query: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#&gt;'{url}') -&gt;&gt; 'href' where jsonb_typeof((o0."data")#&gt;'{url}') = 'array'))::jsonb ?| ($1))  has been...</div><footer></footer></article></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
(mint@ryona.agency)'s status on Friday, 02-Aug-2024 07:23:19 JST
in reply to
- Pleroma-tan
@kirby Frozen federation aside, did you by any chance had cleanup_attachments enabled? For years it did literally nothing, but after some recent commit it apparently started executing some heavy query.
https://git.pleroma.social/pleroma/pleroma/-/issues/1540
In conversationabout 7 months ago from ryona.agencypermalink
Attachments
1. Domain not in remote thumbnail source whitelist: git.pleroma.social
  Some query keeps hammering my DB (#1540) · Issues · Pleroma / pleroma · GitLab
  This query: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1)) has been...

Public

Embed Notice

HTML Code

Corresponding Notice