Intro to query optimization | Postgres.FM 009 |

Описание: 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) https://www.postgresql.org/docs/curre...
https://explain.depesz.com
https://explain.dalibo.com
pgMustard https://www.pgmustard.com/
EverSQL https://www.eversql.com/
pganalyze https://pganalyze.com/
pg_stat_monitor (Extension by Percona) https://github.com/percona/pg_stat_mo...
Recent thread on hackers mailing list about plan_id in pg_stat_activity https://www.postgresql.org/message-id...
auto_explain https://www.postgresql.org/docs/curre...
EXPLAIN observer effect (Ongres blog post by Álvaro Hernández) https://ongres.com/blog/explain_analy...
auto_explain overhead (blog post by Michael) https://www.pgmustard.com/blog/auto-e...
pg_test_timing https://www.postgresql.org/docs/curre...
Database Lab Engine (for thin clones) https://github.com/postgres-ai/databa...
Our previous episode on BUFFERS https://postgres.fm/episodes/buffers-...
EXPLAIN Explained (talk by Josh Berkus)    • EXPLAIN Explained  
A beginner's guide to EXPLAIN (talk by Michael)    • A beginners guide to EXPLAIN ANALYZE – Mic...  
A deeper dive into EXPLAIN (talk by Michael)    • A Deeper Dive into EXPLAIN  
EXPLAIN glossary (pgMustard docs) https://www.pgmustard.com/docs/explain
Topic suggestions document https://docs.google.com/document/d/1P...

-----------------------

What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov   / samokhvalov   and @michristofides   / michristofides  

~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.