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

See All 162 Episodes of "postgres.fm"