Episode 9
Intro to query optimization
Nikolay and Michael discuss query optimization — specifically for a single query, not at the system level.
Postgres FM · Nikolay Samokhvalov and Michael Christofides
September 2, 202233m 14s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Here are links to a few things we mentioned:
- Using EXPLAIN (PostgreSQL documentation)
- explain.depesz.com
- explain.dalibo.com
- pgMustard
- EverSQL
- pganalyze
- pg_stat_monitor (Extension by Percona)
- Recent thread on hackers mailing list about plan_id in pg_stat_activity
- auto_explain
- EXPLAIN observer effect (Ongres blog post by Álvaro Hernández)
- auto_explain overhead (blog post by Michael)
- pg_test_timing
- Database Lab Engine (for thin clones)
- Our previous episode on BUFFERS
- EXPLAIN Explained (talk by Josh Berkus)
- A beginner's guide to EXPLAIN (talk by Michael)
- A deeper dive into EXPLAIN (talk by Michael)
- EXPLAIN glossary (pgMustard docs)
- Topic suggestions document
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofides or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology