Go home #PostgreSQL, you're drunk
Add a LIMIT 10: query now runs 9 times slower
Remove a bunch of WHERE clauses (that do not actually affect result count anywhere): query now runs 6 times slower
???
Follow
Also I am currently rewriting the monster task query for my datasheet scraper from scratch in an attempt to work around previous ill-conceived query plans, I am probably going to regret this
Getting close to query completion, and it's still running in under 200ms \o/
This is like the 4th full day I am spending on this query by the way