Things your explain plan is not telling you

Presented by:

Fee1ac4b2d08c583a3dcdb46cfd095bc

Ants Aasma

from Cybertec
No video of the event yet, sorry!

Checkout the slides

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:
2025 March 7 - 12:15
Duration:
45 min
Room:
Grand Ballroom 2
Conference:
PGConf India, 2025
Language:
Track:
Application Developer
Difficulty:
Medium

Happening at the same time:

  1. Enhancing Security in PostgreSQL: Key Changes from Version 10 to 17
    2. Start Time:
    2025 March 7 12:15

    Room:
    Jupiter

  2. Reliability features in Postgres Pro: BiHA, load balancing and backups
    3. Start Time:
    2025 March 7 12:15

    Room:
    Neptune

  3. Optimising Column Order for Better Performance and Maintainability
    4. Start Time:
    2025 March 7 12:15

    Room:
    Grand Ballroom 1