# darold/pgbadger

A fast PostgreSQL Log Analyzer

Repository: https://github.com/darold/pgbadger
Canonical: https://ross.abutalabs.com/products/pgbadger
Homepage: http://pgbadger.darold.net/
Language: Perl
License: PostgreSQL
License Family: other
Topics: postgresql, perfomance, tuning, sql, log
Last push: 2026-07-14T17:54:44+00:00

## Health v2 (maintenance only)
Score: 72/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 92, release rhythm 31, longevity 100
- inputs: {"age_days": 5257, "days_push": 50, "days_rel": 247, "gap_med": 192.5, "n_releases_24m": 3}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4052, forks 374 (observed 2026-08-28T04:08:33.850366+00:00)

## What it is
pgBadger is a standalone Perl CLI tool that parses PostgreSQL log files (syslog, stderr, csvlog, jsonlog, pgbouncer) and generates detailed HTML performance reports with graphs. It supports parallel processing, incremental reports, and huge or gzip-compressed log files.

## Use cases
- analyze postgresql slow query logs
- generate html reports from postgres logs
- find slowest queries in postgresql
- tune postgresql performance from logs
- parse huge postgres log files fast
- build incremental daily postgres reports
- analyze pgbouncer logs

## When to choose
- you need fast, detailed PostgreSQL log analysis without extra dependencies
- you want HTML reports with graphs from stderr, syslog, csvlog, or jsonlog formats
- you need to parse very large or gzip-compressed log files with parallel processing
- you want incremental daily/weekly cumulative reports

## When to avoid
- you need real-time monitoring or alerting rather than post-hoc log analysis
- your database is not PostgreSQL or pgbouncer
- you want a GUI or hosted dashboard instead of generated HTML reports

## Facets
- artifact type: cli-tool
- maturity: active
- function: parser, analytics, monitoring, developer-tools
- domain: databases, analytics, performance, developer-tools
- platform: cli, cross-platform
- tags: postgresql, log-analysis, reporting, perl, database-performance, html-reports, linux, macos

## Member repositories
- darold/pgbadger (main) score 72

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:33.850366+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:23:39.928005+00:00, confidence not recorded.
  - readme: https://github.com/darold/pgbadger (fetched 2026-08-28T04:08:33.850366+00:00, sha 25cd661b5e5a)
  - homepage: http://pgbadger.darold.net/ (fetched 2026-08-29T09:16:05.018912+00:00, sha b23b215f7cc3)
  - site_page: https://pgbadger.darold.net/documentation.html (fetched 2026-08-29T09:16:05.031380+00:00, sha 3a7e0eff7544)
- Data as of 2026-08-30T08:39:29.467469+00:00.