pgBadger 6.4

This project provides a command-line and fast PostgreSQL log analyzer for Linux.

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in pgBadger 6.1:

  • This release fix some issues and adds some new features. It adds a new option -B or --bar-graph to use bar instead of line in graphs. It will also keep tick formatting when zooming.
  • The release also add a new program: pgbadger_tools to demonstrate how to works with pgBadger binary files to build your own new feature. The first tools 'explain-slowest' allow printing of top slowest queries as EXPLAIN statements. There's also additionnal options to execute automatically the statements with EXPLAIN ANALYZE and get the execution plan. See help of the program for more information or the README file in the tools directory.
  • Some modifications will change certain behavior:
  • The -T | --title text value will now be displayed instead of the pgBadger label right after the logo. report. It was previously displayed on mouse over the pgBadger label.
Read full changelog
send us
an update
BSD License 
5.0/5 1
ROOT \ Internet \ Log Analyzers
6 pgBadger Screenshots:
pgBadger - Usage example of pgBadger from the command-linepgBadger - Usage example of pgBadger from the command-linepgBadger - Usage example of pgBadger from the command-linepgBadger - Usage example of pgBadger from the command-linepgBadger - Usage example of pgBadger from the command-linepgBadger - Usage example of pgBadger from the command-line
pgBadger is an open source and cross-platform software project that has been designed from the ground up to act as a command-line software written in Perl, which can be used by system administrators and database developers to analyze PostgreSQL database logs much faster than if they were using other tools.

Supports detailed reports

Key features include support for viewing detailed reports about SQL queries, including overall statistics, queries that were very slow, queries that took up a lot of time, the most frequently used queries, queries that generated a large number of temporary files, queries that waited the most, queries that generated the biggest temporary files, as well as the most frequent errors.

Supports pie charts

The application also provides users with support for pie charts, allowing them to lock statistics, view queries by type, including delete, insert, select and update, view sessions per user, client or database, view connections per user, client or database, view histogram of query times, display auto-analyze and auto-vacuum per table, as well as to show distribution of queries type per application or database.

Supports time-based charts

In addition to the above, pgBadger also supports time-based charts, which can display statistics about SQL queries, statistics about checkpoints, temporary file statistics, auto-analyze and auto-vacuum statistics, as well as histograms of hourly events or errors, and query duration/count.

Under the hood and supported OSes

The program is written entirely in the Perl programming language, which means that it is a platform-independent application designed to support all GNU/Linux distributions, various BSD flavors, as well as the Microsoft Windows and Mac OS X operating systems. Both 32-bit and 64-bit hardware platforms are supported at this moment.

pgBadger was reviewed by , last updated on April 13th, 2015


#log analyzer #PostgreSQL log #SQL query #PostgreSQL #SQL #query #database

Add your review!