Reddit alternative Lemmy needs SQL optimization help

The federated Reddit alternative Lemmy is being attacked[1] by bots abusing the lack of Postgres query optimization in what is still the early days of the platform. Any assistance with query analysis and optimization would be most appreciated <3

[1] https://lemmy.world/post/2923697