EXPLAIN

Postgres FM

With Nikolay taking a well-earned break, Michael covers the basics of EXPLAIN — what it is, the parameters available, and a process he recommends for using it.
Here are some links to the things mentioned:

• EXPLAIN (docs) https://www.postgresql.org/docs/current/sql-explain.html
• Using EXPLAIN (docs) https://www.postgresql.org/docs/current/using-explain.html
• EXPLAIN Explained (talk by Josh Berkus https://www.youtube.com/watch?app=desktop&v=mCwwFAl1pBU
• Beyond joins and indexes (slides from talk by Bruce Momjian) https://momjian.us/main/writings/pgsql/beyond.pdf
• Depesz https://explain.depesz.com
• Dalibo https://explain.dalibo.com
• pgMustard https://www.pgmustard.com/
• A beginners guide to explain (talk by Michael) https://www.youtube.com/watch?v=31EmOKBP1PY&t=24s
• Explain beyond the basics (talk by Michael) https://www.youtube.com/watch?v=sGkSOvuaPs4
• auto_explain episode https://postgres.fm/episodes/auto_explain
• Row estimates episode https://postgres.fm/episodes/row-estimates
• Slow queries and slow transactions episode https://postgres.fm/episodes/slow-queries-and-slow-transactions
• Benchmarking episode https://postgres.fm/episodes/benchmarking
• EXPLAIN glossary by Michael (forgot to mention, oops!) https://www.pgmustard.com/docs/explain

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

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