darold/pgbadger
Pgbadger
pgBadger es un analizador de logs de PostgreSQL y perfilador de rendimiento de bases de datos que analiza los logs de la base de datos para generar informes detallados sobre consultas lentas y errores del sistema. Funciona como un visualizador de estadísticas, transformando logs crudos en gráficos interactivos para monitorear las tendencias del sistema.
La herramienta utiliza un procesador de logs multinúcleo para distribuir el análisis entre los núcleos de la CPU, acelerando el análisis de grandes volúmenes de logs de actividad de la base de datos. Proporciona un mecanismo para el análisis remoto de logs mediante la recuperación y análisis de archivos desde servidores distantes a través de conexiones SSH.
El sistema cubre el monitoreo de recursos de bases de datos, análisis de logs de pooler de conexiones y visualización de tendencias de rendimiento. Soporta la generación de informes incrementales para crear resúmenes acumulativos y exporta métricas analizadas en formato JSON para su integración con herramientas de monitoreo externas.
Los datos analizados se transforman en informes HTML estáticos e imágenes para su visualización offline.
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.
