Explaining EXPLAIN: A dive into PostgreSQL's EXPLAIN plans

Oct 18 2:00 PM PDT :calendar: to 2:45 pm

About This Talk

There are two types of people: people who want to use Postgres, and people who want to use Postgres well. The latter will not be content with a poorly-performing query when they know that better performance can be achieved with some tuning, an index, and/or a query rewrite. For developers and DBAs, this talk discusses what EXPLAIN does, how to interpret its output, what inferences can be extracted from its output, and what can be done to improve query performance.


    Photo of Richard Yen

    Richard Yen

    Richard has been using PostgreSQL since v. 7.4 in 2003. He is a Principal Support Engineer at EnterpriseDB, providing technical support to DBAs and developers around the world, and works with many clients ranging from private corporations to government organizations and financial institutions.