auto_explain | Postgres.FM 043 |
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/curre...
* ScaleGrid guide https://scalegrid.io/blog/introductio...
* Can auto_explain, with timing, have low overhead? (Blog post by Michael) https://www.pgmustard.com/blog/auto-e...
* pgBadger https://github.com/darold/pgbadger
* pg_stat_monitor https://github.com/percona/pg_stat_mo...
* EXPLAIN ANALYZE may be lying to you (blog post by Álvaro from Ongres) https://ongres.com/blog/explain_analy...
* pg_test_timing https://www.postgresql.org/docs/curre...
* Our episode on benchmarking https://postgres.fm/episodes/benchmar...
* Database Lab Engine https://github.com/postgres-ai/databa...
~~~
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 / samokhvalov and @michristofides / 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.