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:

• 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 …

databases postgres postgresql sql technology