macOS
Homebrew已验证 · 100%
brew install pgbadgerlocal Homebrew formula metadata
MacPorts已验证 · 94%
sudo port install pgbadgerMacPorts ports tree · databases/pgbadger/Portfile · 来源: api.github.com
安装
其他安装命令
Linux
Alpine Linux apk已验证 · 92%
sudo apk add pgbadgerAlpine Linux edge package indexes · pgbadger · 来源: dl-cdn.alpinelinux.org
Debian apt已验证 · 92%
sudo apt install pgbadgerDebian stable package indexes · pgbadger · 来源: deb.debian.org
Fedora dnf已验证 · 92%
sudo dnf install pgbadgerFedora Rawhide package metadata · pgbadger · 来源: dl.fedoraproject.org
Nix已验证 · 92%
nix profile install nixpkgs#pgbadgernixpkgs package indexes · pgbadger · 来源: raw.githubusercontent.com
openSUSE zypper已验证 · 92%
sudo zypper install pgbadgeropenSUSE Tumbleweed package metadata · pgbadger · 来源: download.opensuse.org
概览
软件包摘要
Log analyzer for PostgreSQL
历史
项目历史与用法
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.
项目历史
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.
采用历史
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.
使用方式
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.
为什么软件包爱好者会关心
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.
时间线
- 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.
来源
安全态势
风险级别：blue
broad file, network, media, or database tool signal.
风险分类器
blue 风险 · 中 置信度 · tool
原因
- broad file, network, media, or database tool signal
信号
- text:sql
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 5 个平台目标。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
pgbadger | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-11-04
管理器版本13.2
管理器更新时间2026-11-03
本地数据OK
上游当前
检测到的最新版本v13.3
https://github.com/darold/pgbadger
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:pgbadger |
|---|---|
| 版本 | 13.2 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/pgbadger |
| 主页 | https://pgbadger.darold.net/ |
| 仓库 | https://github.com/darold/pgbadger |
| 上游文档 | https://pgbadger.darold.net/ |
| 许可证 | PostgreSQL |
| 源码归档 | https://github.com/darold/pgbadger/archive/refs/tags/v13.3.tar.gz |
| 最后更新 | 2026-11-03T11:38:39Z |
| Pulse | updated |
| Bottle | 可用 (于 arm64_golden_gate, arm64_linux, arm64_sequoia, arm64_tahoe, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
| 注意事项 | 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' |
注册表事实
源数据库详情
| 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 |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
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 依赖
- normalized package name match
- 匹配方式：Pgbadger
Nix95%
pgbadger
nix profile install nixpkgs#pgbadger- normalized package name match
- 匹配方式：Pgbadger
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 依赖
- normalized package name match
- 匹配方式：Pgbadger
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 提供
- normalized package name match
- 匹配方式：Pgbadger
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
- 匹配方式：Pgbadger
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 依赖
- 1 提供
- normalized package name match
- 匹配方式：Pgbadger
zypper95%
pgbadger 13.2-1.5
A fast PostgreSQL log analyzer
sudo zypper install pgbadger- License: MIT
- Category: System/Monitoring
- Architecture: noarch
- Source Package: pgbadger
- 3 依赖
- 2 提供
- normalized package name match
- 匹配方式：Pgbadger
MacPorts95%
pgbadger
sudo port install pgbadger- normalized package name match
- 匹配方式：Pgbadger
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- 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