darold/pgbadger
Pgbadger
pgBadger 是一个 PostgreSQL 日志分析器和数据库性能分析器，解析数据库日志以生成关于慢查询和系统错误的详细报告。它作为统计可视化工具，将原始日志转换为交互式图表，以监控系统趋势。
该工具利用多核日志处理器将解析任务分配到 CPU 核心，加速对大量数据库活动日志的分析。它提供了一种远程日志分析机制，通过安全 Shell 连接从远程服务器检索和解析文件。
该系统涵盖数据库资源监控、连接池日志分析和性能趋势可视化。它支持生成增量报告以创建累积摘要，并以 JSON 格式导出分析指标，以便与外部监控工具集成。
分析后的数据被转换为静态 HTML 报告和图像，供离线查看。
Features
- PostgreSQL Performance Monitoring - Analyzes PostgreSQL database log files to identify slow queries and system errors to improve database speed.
- Parallel Log Parsing - Utilizes a multi-core log processor to distribute parsing across CPU cores, significantly accelerating the analysis of large log volumes.
- Database Performance Profiling - Identifies bottlenecks, temporary file usage, and error distributions within database log files.
- Database Performance Monitoring - Tracks query duration, request throughput, and active session counts to monitor database resource utilization.
- Log Statistics Visualizers - Transforms raw database logs into interactive charts and graphs to monitor system trends.
- Log File Parsing - Parses database log files in multiple formats to generate detailed performance reports.
- Log Management Systems - Processes large volumes of PostgreSQL database logs into readable reports and summaries.
- Performance Trend Analysis - Transforms raw database logs into interactive charts and graphs to visualize system activity and performance trends.
- Portable HTML Reports - Transforms analyzed metrics into self-contained, interlinked static HTML pages and images for offline viewing.
- Incremental Log Processing - Processes logs in successive runs to create cumulative daily and weekly summaries of system performance.
- Parallel Log Parsing - Utilizes multi-core parallel processing to accelerate the analysis of large database log files.
- Remote Database Log Retrieval - Fetches logs from distant servers over secure shell tunnels for centralized analysis without local file copies.
- Parallel Log Processing - Uses parallel processing across multiple CPU cores to analyze large volumes of database activity logs.
- Connection Pooler Statistics - Processes connection pooler logs to report on request throughput, query duration, and active session counts.
- Remote Log Parsing - Retrieves and analyzes log files from remote servers via secure shell connections to identify system issues.
- Cumulative Summaries - Generates cumulative daily and weekly performance summaries by processing logs in successive runs.
- Remote Logging Utilities - Retrieves and parses log files from remote servers via secure shell to diagnose issues without manual transfers.
- Performance and Optimization - Fast log analyzer for PostgreSQL.
