brew / rank 5176

Install pgbadger with Homebrew, apk, apt, dnf, MacPorts, Nix, zypper

Log analyzer for PostgreSQL. Version 13.2 via Homebrew; verified 2026-11-03. Also installable with debian: sudo apt install pgbadger.

Install command Security notes

install

Additional install commands

macOS

Homebrewverified · 100%

brew install pgbadger

local Homebrew formula metadata

MacPortsverified · 94%

sudo port install pgbadger

MacPorts ports tree · databases/pgbadger/Portfile · source: api.github.com

Linux

Alpine Linux apkverified · 92%

sudo apk add pgbadger

Alpine Linux edge package indexes · pgbadger · source: dl-cdn.alpinelinux.org

Debian aptverified · 92%

sudo apt install pgbadger

Debian stable package indexes · pgbadger · source: deb.debian.org

Fedora dnfverified · 92%

sudo dnf install pgbadger

Fedora Rawhide package metadata · pgbadger · source: dl.fedoraproject.org

Nixverified · 92%

nix profile install nixpkgs#pgbadger

nixpkgs package indexes · pgbadger · source: raw.githubusercontent.com

openSUSE zypperverified · 92%

sudo zypper install pgbadger

openSUSE Tumbleweed package metadata · pgbadger · source: download.opensuse.org

overview

Package summary

Log analyzer for PostgreSQL

Project links

Commands and aliases

pgbadger

history

Project history and usage

pgBadger is an offline PostgreSQL log analyzer that generates interactive HTML and other report formats for query performance, sessions, locks, checkpoints, autovacuum, errors, and related operational activity.

Project history

Gilles Darold created pgBadger as a fast PostgreSQL log analyzer and released its early series in 2012. It was positioned as a replacement for the older pgFouine workflow and used JavaScript-rendered graphs in self-contained reports.

The project added incremental reporting, additional log formats, richer performance and error analysis, and multiple machine-readable outputs while retaining a command-line workflow and PostgreSQL license.

Adoption history

pgBadger's single-command, pure-Perl design and ability to work from existing log files made it straightforward to package and run on database hosts, reporting hosts, and administrative workstations. source_facts.package-manager records availability across Homebrew and several major Unix distribution ecosystems.

Support expanded beyond ordinary PostgreSQL stderr logs to formats and environments including csvlog, jsonlog, syslog, cloud-hosted PostgreSQL logs, compressed or remote inputs, and PgBouncer statistics logs.

How it is used

DBAs run pgBadger against one or more local, compressed, remote, or streamed log inputs. Common uses include identifying slow or frequent queries, inspecting errors and lock activity, evaluating checkpoints and autovacuum, and generating scheduled daily or weekly reports.

Why package nerds care

pgBadger represents the classic Unix package pattern of converting already-available operational text into a portable artifact. It provides deep PostgreSQL-specific analysis and shareable HTML reports without requiring a permanently running agent or monitoring service.

Timeline

2012: The first pgBadger release series established the PostgreSQL log-analysis and HTML-report workflow.
2014: Incremental reporting enabled cumulative scheduled reports.
2018: The 10.x series introduced a redesigned reporting interface.

Related projects

pgBadger complements live PostgreSQL activity monitors by providing retrospective analysis of retained logs. It also directly understands PgBouncer log formats, allowing the pooler and database logs to participate in the same reporting workflow.

Sources

https://github.com/darold/pgbadger/blob/master/ChangeLog
https://pgbadger.darold.net/
https://pgbadger.darold.net/documentation.html
source_facts.package-manager

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

broad file, network, media, or database tool signal

Signals

text:sql

Install behavior

No Homebrew post-install hook is recorded in formula metadata.
Homebrew bottle metadata is available for 5 platform targets.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

Command	Kind	Exposure	Note
`pgbadger`	cli	global executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-11-04

manager version13.2

manager updated2026-11-03

local dataok

upstreamcurrent

latest detectedv13.3

https://github.com/darold/pgbadger

okNo freshness warnings were generated.

install metadata

Package metadata

Package key	brew:pgbadger
Version	13.2
Package manager	Homebrew
Package manager page	https://formulae.brew.sh/formula/pgbadger
Homepage	https://pgbadger.darold.net/
Repository	https://github.com/darold/pgbadger
Upstream docs	https://pgbadger.darold.net/
License	PostgreSQL
Source archive	https://github.com/darold/pgbadger/archive/refs/tags/v13.3.tar.gz
Last updated	2026-11-03T11:38:39Z
Pulse	updated
Bottle	available (on arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux)
Homebrew post-install	not defined
Service	none declared
Caveats	You must configure your PostgreSQL server before using pgBadger. Edit postgresql.conf (in $HOMEBREW_PREFIX/var/postgres if you use Homebrew's PostgreSQL), set the following parameters, and restart PostgreSQL: log_destination = 'stderr' log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d ' log_statement = 'none' log_duration = off log_min_duration_statement = 0 log_checkpoints = on log_connections = on log_disconnections = on log_lock_waits = on log_temp_files = 0 lc_messages = 'C'

registry facts

Source database details

Source Database	Homebrew formula API
Tap	homebrew/core
Full Name	pgbadger
Version Scheme	0
Revision	0
Head Version	HEAD
Bottle Stable Root URL	https://ghcr.io/v2/homebrew/core
Deprecated	no
Disabled	no
Keg Only	no
URL Keys	head stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

pgbadger 13.1-1

Fast PostgreSQL log analysis report

https://dalibo.github.io/pgbadger/

sudo apt install pgbadger

Section: admin
Architecture: all
3 dependencies
normalized package name match
Matched by: Pgbadger

Debian stable package indexes · deb.debian.org · Debian stable package indexes: pgbadger from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz

Nix95%

pgbadger

nix profile install nixpkgs#pgbadger

normalized package name match
Matched by: Pgbadger

nixpkgs package indexes · raw.githubusercontent.com · nixpkgs package indexes: pgbadger from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix

Ubuntu apt95%

pgbadger 12.4-1

Fast PostgreSQL log analysis report

https://dalibo.github.io/pgbadger/

sudo apt install pgbadger

Section: universe/admin
Architecture: all
3 dependencies
normalized package name match
Matched by: Pgbadger

Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: pgbadger from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz

apk95%

pgbadger 12.4-r1

A fast PostgreSQL Log Analyzer

https://github.com/darold/pgbadger

sudo apk add pgbadger

License: Custom
Architecture: x86_64
Source Package: pgbadger
1 provides
normalized package name match
Matched by: Pgbadger

Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pgbadger from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz

apk95%

pgbadger-doc 12.4-r1

A fast PostgreSQL Log Analyzer (documentation)

https://github.com/darold/pgbadger

sudo apk add pgbadger-doc

License: Custom
Architecture: x86_64
Source Package: pgbadger
normalized package name match
Matched by: Pgbadger

Alpine Linux edge package indexes · dl-cdn.alpinelinux.org · Alpine Linux edge package indexes: pgbadger-doc from https://dl-cdn.alpinelinux.org/alpine/edge/community/x86_64/APKINDEX.tar.gz

dnf95%

pgbadger 13.2-4.fc45

PostgreSQL log analyzer with fully detailed reports and graphs

https://github.com/darold/pgbadger

sudo dnf install pgbadger

License: PostgreSQL AND MIT AND Artistic-2.0 AND OFL-1.1 AND CC-BY-3.0 AND GPL-2.0-only
Category: Unspecified
Architecture: noarch
Source Package: pgbadger
2 dependencies
1 provides
normalized package name match
Matched by: Pgbadger

Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: pgbadger from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst

zypper95%

pgbadger 13.2-1.5

A fast PostgreSQL log analyzer

https://pgbadger.darold.net/

sudo zypper install pgbadger

License: MIT
Category: System/Monitoring
Architecture: noarch
Source Package: pgbadger
3 dependencies
2 provides
normalized package name match
Matched by: Pgbadger

openSUSE Tumbleweed package metadata · download.opensuse.org · openSUSE Tumbleweed package metadata: pgbadger from https://download.opensuse.org/tumbleweed/repo/oss/repodata/d310d5a96106e1e8872a385adf98aaa23be9db5d80937a6717314e7e7f37715065c6c748ab7ccee6475d620b46979c0fe64235fc0c46988e17edf659578fcf31-primary.xml.zst

MacPorts95%

pgbadger

sudo port install pgbadger

normalized package name match
Matched by: Pgbadger

MacPorts ports tree · api.github.com · MacPorts ports tree: databases/pgbadger/Portfile from https://api.github.com/repos/macports/macports-ports/git/trees/master?recursive=1

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Combined YAML source

View the package source record on GitHub.

combined/pgbadger.yml

Used sources

Geiger risk classifier
cross-ecosystem install command graph
curated package history
external package-manager database matches
package relationship graph
package version freshness
package-page enrichment
pkg.so package database
pkgdb category and tag curation

Install pgbadger with Homebrew, apk, apt, dnf, MacPorts, Nix, zypper

Additional install commands

macOS

Linux

Package summary

Project links

Commands and aliases

Project history and usage

Project history

Adoption history

How it is used

Why package nerds care

Timeline

Related projects

Sources

Risk level: blue

Risk classifier

Why

Signals

Install behavior

Recommended review

Installed executables

Version and freshness

Package metadata

Source database details

Other package-manager records

Internal package links

Topical hubs

Same workflow

Generated from repository data

Combined YAML source

Used sources