Presented by:

Fee1ac4b2d08c583a3dcdb46cfd095bc

Ants Aasma

from Cybertec
No video of the event yet, sorry!

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.

Date:
Duration:
45 min
Room:
Conference:
PGConf India, 2025
Language:
Track:
Application Developer
Difficulty:
Medium