awesome-repositories.com
Blog
MCP
awesome-repositories.com

Discover the best open-source repositories with AI-powered search.

ExploreCurated searchesOpen-source alternativesSelf-hosted softwareBlogSitemap
ProjectMCP serverAboutHow we rankPress
LegalPrivacyTerms
© 2026 Bringes Technology SRL·VAT RO45896025·hello@awesome-repositories.com
darold avatar

darold/pgbadger

0
View on GitHub↗
pgbadger.darold.net↗

Pgbadger

pgBadger is a PostgreSQL log analyzer and database performance profiler that parses database logs to generate detailed reports on slow queries and system errors. It functions as a statistics visualizer, transforming raw logs into interactive charts and graphs to monitor system trends.

The tool utilizes a multi-core log processor to distribute parsing across CPU cores, accelerating the analysis of large volumes of database activity logs. It provides a mechanism for remote log analysis by retrieving and parsing files from distant servers via secure shell connections.

The system covers database resource monitoring, connection pooler log analysis, and performance trend visualization. It supports the generation of incremental reports to create cumulative summaries and exports analyzed metrics in JSON format for integration with external monitoring tools.

The analyzed data is transformed into static HTML reports and images for offline viewing.

AI search

Explore more awesome repositories

Describe what you need in plain English — the AI ranks thousands of curated open-source projects by relevance.

Start searching with AI

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.
4,074 stars·378 forks·Perl·PostgreSQL·23 views

Star history

Star history chart for darold/pgbadgerStar history chart for darold/pgbadger

How this analysis was created: This summary and feature list are AI-generated from collected project material and can contain mistakes. Stars, license and language are imported from GitHub. Inclusion does not mean that we have tested or audited this project. Check the source documentation for any feature you depend on. Learn more on our About page.

Frequently asked questions

What does darold/pgbadger do?

pgBadger is a PostgreSQL log analyzer and database performance profiler that parses database logs to generate detailed reports on slow queries and system errors. It functions as a statistics visualizer, transforming raw logs into interactive charts and graphs to monitor system trends.

What are the main features of darold/pgbadger?

The main features of darold/pgbadger are: PostgreSQL Performance Monitoring, Parallel Log Parsing, Database Performance Profiling, Database Performance Monitoring, Log Statistics Visualizers, Log File Parsing, Log Management Systems, Performance Trend Analysis.

Which projects share features with darold/pgbadger?

Projects with overlapping indexed features include: ankane/pghero — PgHero is a performance dashboard and diagnostic tool for PostgreSQL. It provides a web interface for monitoring… uptrace/uptrace — Uptrace is an OpenTelemetry-based observability platform designed to collect, store, and analyze distributed traces,… pgsty/pigsty — Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL… ghostpack/seatbelt — Seatbelt is a C# offensive security framework and host security auditor designed to perform endpoint surveys on… analogj/scrutiny — Scrutiny is a distributed hardware monitoring system and predictive drive failure analyzer. It provides a centralized… google/battery-historian — Battery Historian is a visualization and profiling tool for analyzing power consumption and battery drain on Android…

Projects sharing features with Pgbadger

These projects share indexed features with Pgbadger. Shared tags can include platform or build tooling; verify the primary use case before treating a result as a replacement.
  • ankane/pgheroankane avatar

    ankane/pghero

    8,880View on GitHub↗

    PgHero is a performance dashboard and diagnostic tool for PostgreSQL. It provides a web interface for monitoring database metrics, analyzing query performance, and managing active connections across multiple database instances. The project distinguishes itself by recording query and storage statistics over time, enabling historical trend analysis through a time-range slider. It also identifies missing indexes by analyzing query patterns and integrates with cloud provider APIs to retrieve system-level hardware statistics such as CPU and IOPS. The tool's broader capabilities cover process admi

    Ruby
    View on GitHub↗8,880
  • uptrace/uptraceuptrace avatar

    uptrace/uptrace

    4,311View on GitHub↗

    Uptrace is an OpenTelemetry-based observability platform designed to collect, store, and analyze distributed traces, metrics, and logs. It functions as a centralized logging backend, a distributed tracing system, and a metrics engine to monitor application performance and system health. The platform is distinguished by AI-powered operational capabilities, allowing users to query telemetry data and manage monitoring dashboards using natural language. It specifically includes specialized monitoring for generative AI pipelines, tracking token usage and response quality for LLM interactions and r

    Goapmapplication-monitoringclickhouse
    View on GitHub↗4,311
  • pgsty/pigstypgsty avatar

    pgsty/pigsty

    5,914View on GitHub↗

    Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL clusters and their supporting infrastructure. It functions as a cluster management platform and high-availability suite that automates failover, manages virtual IPs, and ensures data consistency through distributed consensus. The project distinguishes itself by providing a comprehensive database infrastructure-as-code framework and a dedicated observability stack. It incorporates a backup and recovery manager supporting point-in-time recovery via S3-compatible object storage, alongs

    Shellgraphicsinfrapostgres
    View on GitHub↗5,914
  • ghostpack/seatbeltGhostPack avatar

    GhostPack/Seatbelt

    4,757View on GitHub↗

    Seatbelt is a C# offensive security framework and host security auditor designed to perform endpoint surveys on Windows systems. It functions as a modular tool for identifying vulnerabilities, misconfigurations, and security-relevant artifacts on both local and remote hosts. The project distinguishes itself through a module-based check system that allows for the integration of custom security command units. It features a security event log parser to track logon and process activity, alongside a credential extraction utility for gathering browser history, saved passwords, and cloud credentials

    C#
    View on GitHub↗4,757
Compare all 30 related projects→