Intro to query optimization
Nikolay and Michael discuss query optimization — specifically for a single query, not at the system level.
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 amazing artwork
