@verita84eva @colonelj damn, the bulk would be in CREATE activities then, doubt much would break if you deleted them, since you're clearing the objects by age too

time to make a dump and report back if anything breaks after deleting a few months of them

pleroma=> select count(*), date_trunc('month', inserted_at) from activities where data->>'type' = 'Create' and local = 'f' group by date_trunc('month', inserted_at) order by date_trunc('month', inserted_at);
count | date_trunc
---------+---------------------
882593 | 2023-03-01 00:00:00
3404857 | 2023-04-01 00:00:00
3695948 | 2023-05-01 00:00:00
3067730 | 2023-06-01 00:00:00
4033487 | 2023-07-01 00:00:00
4050590 | 2023-08-01 00:00:00
604380 | 2023-09-01 00:00:00
19969 | 2023-10-01 00:00:00
712353 | 2023-11-01 00:00:00
1842379 | 2023-12-01 00:00:00
4198836 | 2024-01-01 00:00:00
3653179 | 2024-02-01 00:00:00
4249558 | 2024-03-01 00:00:00
2461312 | 2024-04-01 00:00:00
(14 rows)

pleroma=> select count(*) from activities where data->>'type' = 'Create' and local = 'f' and inserted_at < now() - interval '365 days';
count
---------
3778169
(1 row)