Schedule - PGConf.DE 2024

Things your explain plan is not telling you

Date: 2024-04-12
Time: 15:55–16:45
Room: Ballsaal 3
Level: Intermediate

As much as we all love PostgreSQL explain command for diagnosing performance issues, there are some things that it doesn't reveal to us. In this talk I will take a look at some of the hidden performance gremlins and how to spot them in your plans. Things like TOAST lookups, visibility checks, hint bits and expression evaluation time can sometimes turn up in surprising places in your execution plans with little to no indication that this is happening. Knowing how to look for these problems is already a large step towards solving them.

Slides

The following slides have been made available for this session:

Speaker

Ants Aasma