@Humpleupagus @cassidyclown @lina @mint Aside from 30 days interval and direct references, you may also want to consider following relationships of local users, with follows as ( select distinct ap_id from following_relationships join users on users.id = following_relationships.following_id ), ids as ( ... join objects on ... not ( ... or exists (select 1 from follows where activities.data::text like '%' || ap_id || '%' or objects.data::text like '%' || ap_id || '%') ) ) ... But it would be very slow. Checking specific fields, e.g. actor/announces/from/to/cc/bcc and using array operators can improve the performance, but it can still be a lot of relations to process for each status.