@phnt @dcc @sun posts don't have the associated emoji included, but emoji can have dozens of tagged profiles that pleroma will try to pull if you're downstream of the thread

select count(*), jsonb_array_length(data->'tag') from activities where data->>'type' = 'EmojiReact' group by jsonb_array_length(data->'tag') order by jsonb_array_length(data->'tag') desc;

and yes the pinned post fetching is problematic too, because it's another area where you have a persistent retry loop whenever the profile caches out for a refetch