Carpe diem! The Call-for-Proposals (CFP) for our new, free, & virtual developer event is open until Feb 6th. Learn more in the CFP for Citus Con: An Event for Postgres.
If you’ve done some performance tuning with Postgres, you might have used
EXPLAIN shows you the execution plan that the PostgreSQL planner generates for the supplied statement. It shows how the table(s) referenced by the statement will be scanned (using a sequential scan, index scan etc), and what join algorithms will be used if multiple tables are used. But, how does Postgres come up with these plans?