Best Practices for Tuning Slow Postgres Queries | POSETTE: An Event for Postgres 2025

Video of a conference talk where Lukas Fittl walks through what he’s learned tuning slow Postgres queries over the years. He'll start with a quick recap of the basics (EXPLAIN ANALYZE) and then go through his iterative process of how he evaluates the root cause of a query's slowness.

To help you identify root causes more effectively, he'll go through common pathological Postgres planner decisions that can make a query slower than it should be and discuss when you may want to use tools like pg_hint_plan to understand alternate query plans that are available but not chosen by Postgres.

Lukas Fittl is Founder & CEO at pganalyze.com, hosted PostgreSQL Performance Monitoring, the author of pg_query (Ruby extension to parse queries using the raw_parser) and other tools. Lukas loves working with PostgreSQL statistics and visualizing them.

► Video bookmarks:

⏩ 00:10 Introduction - Best Practices for Tuning Slow Postgres Queries
⏩ 00:52 Debugging why a Query is Slow
⏩ 02:37 Benchmarking with EXPLAIN(ANALYZE, BUFFERS)
⏩ 05:41 Planner Costing & Why it Can Never be Perfect
⏩ 11:32 Join Order & Parameterized Index Scans
⏩ 19:30 Guiding the Planner to the Right Plan
⏩ 22:27 Conclusion

📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com

✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist

📌 Let’s connect:  
LinkedIn -   / posetteconf  
X – @PosetteConf,   / posetteconf  
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com

_________________________________
#PosetteConf #PostgreSQL #performance