Interesting. So when you query subscriptions, it actually queries everything and then filters it.

I decided to look at the github for Lemmy and found this issue that seems to reflect what youre saying.

I’m having flashbacks of avoiding table scans during my internship. 🙂