auto_explain | Postgres.FM 043 | #PostgreSQL #Postgres podcast

Описание

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 https://www.postgresql.org/docs/current/auto-explain.html
* ScaleGrid guide https://scalegrid.io/blog/introduction-to-auto-explain-postgres/
* Can auto_explain, with timing, have low overhead? (Blog post by Michael) https://www.pgmustard.com/blog/auto-explain-overhead-with-timing
* pgBadger https://github.com/darold/pgbadger
* pg_stat_monitor https://github.com/percona/pg_stat_monitor
* EXPLAIN ANALYZE may be lying to you (blog post by Álvaro from Ongres) https://ongres.com/blog/explain_analyze_may_be_lying_to_you/
* pg_test_timing https://www.postgresql.org/docs/current/pgtesttiming.html
* Our episode on benchmarking https://postgres.fm/episodes/benchmarking
* Database Lab Engine https://github.com/postgres-ai/database-lab-engine


~~~

What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides

~~~

Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard

~~~

This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.