Re: Extremely slow HashAggregate in simple UNION query

[Michael Lewis]

I believe this would be relevant-
https://www.cybertec-postgresql.com/en/optimizer-support-functions/

It seems there is hope down the road to improve those estimates.