EXPLAIN
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:
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!
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
