Conference Schedule - pgDay Paris 2020

Making The Most of EXPLAIN

Date: 2020-03-26
Time: 11:10 - 11:55
Room: Auditorium

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.


Lukas Fittl