Some query keeps hammering my DB
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 hammering my DB on and off all day. One process of it uses around 50% of my CPU and I've counted up to five at once causing Pleroma to start throwing 500s.
It's likely not related to favourites or tags as I return 404s for those until they get fixed.