auto_explain | Postgres.FM 043 |
Автор: PostgresTV
Загружено: 2023-04-28
Просмотров: 483
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.
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: