pgBadger | Postgres.FM 080 |  

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RU-vid's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Michael is joined by Alicja Kucharczyk ( / stiepantrofimo , Program Manager for Azure Database for PostgreSQL at Microsoft and organiser of the Warsaw PostgreSQL User Group, to discuss Alicja's favorite tool: pgBadger. They cover what it is, how and when it's useful, and some guidance for getting the most out of it (without causing an outage).
Here are some links to things they mentioned:
* pgBadger website pgbadger.darol...
* pgBadger repo github.com/dar...
* An example pgBadger report pgbadger.darol...
* pg_stat_statements www.postgresql...
* Azure Guide techcommunity....
* Google Cloud SQL guide cloud.google.c...
* RDS guide aws.amazon.com...
* Community Insights on pgBadger (PGSQL Phriday Recap) techcommunity....
* PGSQL Phriday #010: Log analysis (blog post by Lætitia Avrot) mydbanotebook....
* Nothing Compares To VACUUM/The Ballad of Bloat • Nothing Compares To VA...
* Explain Analyze (Feliz Navidad cover) • Explain Analyze (Feliz...
~~~
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 produced by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to find the audio-optimised version.