Untitled attachment
https://eientei.org/media/05/48/8c/05488ccdda689d4b5b3a2a85b59ec9607131cbe1d3ebfc33e40fc03ae71fe5bf.png?name=image.png
starting to feel like a fucking failure
I think I'll try to safely terminate the query. I'm not a database expert but that triple left join looks inefficient as hell, especially when
pleroma=# SELECT count(*) FROM public.activities; count ----------- 105514556 (1 row)I hope it was actually deleting rows all along and not just calculating what to delete. that would mean 13 wasted days
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.