Making The Most of EXPLAIN


One of the most powerful commands in Postgres: EXPLAIN. It can teach you all the details about what your queries are actually up to when they get planned and executed.

There is a lot more than just running the command though. What does cost actually mean? What is the basic structure of a plan? How is a JOIN represented? Are Nested Loops bad?

We’ll spend time looking at examples of how to read EXPLAIN plans, learn about specific plan nodes, and how to improve the performance of a slow query using the query plan.

Room 105
Friday, March 6, 2020 - 14:15 to 15:00