pgbadger

brew install pgbadger v13.2 PostgreSQL

Log analyzer for PostgreSQL

30-day installs · #6488

90-day · #5836

581

365-day · #4816

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'

Raw metadata

{
  "aliases": [],
  "alternatives": [],
  "build_dependencies": [],
  "categories": [],
  "caveats": "You must configure your PostgreSQL server before using pgBadger.\nEdit postgresql.conf (in $HOMEBREW_PREFIX/var/postgres if you use Homebrew\u0027s\nPostgreSQL), set the following parameters, and restart PostgreSQL:\n\n  log_destination = \u0027stderr\u0027\n  log_line_prefix = \u0027%t [%p]: [%l-1] user=%u,db=%d \u0027\n  log_statement = \u0027none\u0027\n  log_duration = off\n  log_min_duration_statement = 0\n  log_checkpoints = on\n  log_connections = on\n  log_disconnections = on\n  log_lock_waits = on\n  log_temp_files = 0\n  lc_messages = \u0027C\u0027\n",
  "conflicts_with": [],
  "dependencies": [],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Log analyzer for PostgreSQL",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": null,
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "pgbadger",
  "github_default_branch": null,
  "github_last_commit_at": null,
  "github_readme_excerpt": null,
  "github_repo": null,
  "github_stars": null,
  "github_topics": [],
  "homepage": "https://pgbadger.darold.net/",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": null,
  "installs_30d": 23,
  "installs_365d": 581,
  "installs_90d": 90,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "PostgreSQL",
  "llm_generated_at": null,
  "llm_model": null,
  "name": "pgbadger",
  "oldnames": [],
  "one_liner": null,
  "optional_dependencies": [],
  "rank_30d": 6488,
  "rank_365d": 4816,
  "rank_90d": 5836,
  "raw_hash": "34cb97244e9c6e28",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/p/pgbadger.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [],
  "version_head": "HEAD",
  "version_stable": "13.2",
  "versioned_formulae": [],
  "why_use_this": null
}

pgbadger

Links

Caveats