Schedule - PGConf.EU 2023

Leveraging pgBadger for Effective PostgreSQL Troubleshooting

Date: 2023-12-15
Time: 14:40–15:30
Room: Zenit

pgBadger stands as one of the most comprehensive and widely adopted tools for diagnosing issues and analyzing the current state of a PostgreSQL database. As an open-source utility that's platform-agnostic and easy to use, it offers users in-depth insights into a myriad of events occurring within their databases.

This includes visibility into the activities of the autovacuum daemon, such as the number of ANALYZE and VACUUM operations it calls, the tables affected, and the quantity of rows and pages deleted. In addition, pgBadger allows analysis of the distribution and sizes of temporary files, including the queries that generate them. Furthermore, it offers understanding into the types of locks within the system, the most frequent waiting queries, and the longest waiting ones, although it doesn't provide information about which query held a lock.

In this session, we will delve into select use cases of interpreting a pgBadger report and deciding on necessary interventions when encountering specific "red flags". Learn how to harness the potential of pgBadger within a focused scope, turning diagnostic data into actionable strategies to enhance the performance and stability of your PostgreSQL operations. This session aims to improve your PostgreSQL troubleshooting skills by providing a comprehensive understanding of specific use cases in your database management process.


Alicja Kucharczyk