Episode 43
auto_explain
Postgres FM · Nikolay Samokhvalov and Michael Christofides
April 28, 202337m 18s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Nikolay and Michael discuss auto_explain — what it is, how it can help, and how to check it's overhead.
Here are links to a few things we mentioned:
- auto_explain (docs)
- ScaleGrid guide to auto_explain
- Can auto_explain, with timing, have low overhead? (Blog post by Michael)
- pgBadger
- pg_stat_monitor
- EXPLAIN ANALYZE may be lying to you (blog post by Álvaro from Ongres)
- pg_test_timing
- Our episode on benchmarking
- Database Lab Engine
~~~
What did you like or not like? What should we discuss next time? Let us know on YouTube, on social media, 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
Topics
PostgresPostgreSQLDatabasesSQLtechnology