Conference Schedule - pgDay Paris 2020
Making The Most of EXPLAIN
Time: 11:10 - 11:55
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.