I give credit to the admins of Lemmy.world. Because their instance blew up in popularity, they went through and did some optimizations to DB and other queries. What's even better is they've submitted the PRs so all instances can scale as smoothly going forward.