The Importance of Buffers and Timing

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