Schedule - Nordic PGDay 2025
Your PostgreSQL Database performance radar: pgBadger
Date: 2025-03-18
Time: 14:05–14:55
Room: Main Room
Level: Intermediate
As a dba, database performance benchmarking and improvement has always been of utmost importance to me and pgBadger has been my go to utility for it.
What makes pgBadger so usable is the effortless setup and the easy-to-read output reports. All that is needed is the Postgres database logs. Postgres logs is very informative, however, it can be sometimes very large in size and granularity and can be difficult to analyse in raw form, especially in crucial productive environments. "pgBadger" does an excellent job in such scenarios by generating a detailed and categorised report based on the logs, thus helping with quick and efficient troubleshooting and analysis of varied issues and Db activities. The reports can also be used to compare DB performance after any new change, migration or for proactively tuning the existing resources.
In this talk, we will discuss: what is Pgbadger,how to install it, how to create a report, When can pgbadger help and various available options to customise the report as per need, a walk through of the various sections in the report, use cases showing how pgbadger report can be used to solve or improve Db performance quickly, Hows and whats of the incremental and cumulative mode.
Learning about this tool will be useful for DBAs, developers, decision makers or anyone who need to see how their queries and databases are functioning over a short or long period of time.
