How PostgreSQL Estimates Your Queries (And Why It Sometimes Gets It Wrong)
Every query starts with a plan. Every slow query probably starts with a bad one. And more often than not, the statistics are to blame. But how does it really work? PostgreSQL doesn’t run the query to find out — it …