ankane/pghero
Pghero
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 administration, including the ability to terminate long-running queries, and infrastructure observability, such as tracking replication lag and storage growth. It includes administrative utilities for database user management and dashboard access control.
Features
- PostgreSQL Performance Monitoring - Provides a comprehensive dashboard for tracking database metrics and visualizing bottlenecks in PostgreSQL instances.
- Time-Series Performance Snapshots - Records time-series snapshots of storage and query data to enable historical trend analysis via a time-range slider.
- Query Optimizers - Analyzes query patterns and identifies missing indexes to reduce response times and improve database speed.
- PostgreSQL Administration Tools - Enables administration of active database connections and the termination of long-running queries.
- System Catalog Metric Aggregation - Executes periodic SQL queries against system catalogs to extract and visualize database performance statistics.
- Query Performance Analyzers - Records query history and visualizes performance trends over time to optimize database execution speed.
- Query Statistics Repositories - Records query statistics over time in dedicated tables to enable historical trend analysis.
- Missing Index Identification - Analyzes query patterns to identify and suggest missing indexes to reduce database response times.
- Database Performance Monitors - Provides a dashboard for monitoring real-time metrics and terminating long-running database processes.
- Query Terminators - Allows administrators to terminate specific long-running queries or kill all active processes to resolve contention.
- Multi-Database Connection Configuration - Allows simultaneous connection to several database instances or replicas through a configuration file.
- Database Growth Tracking - Tracks the growth of databases and schemas over time to assist in disk space capacity planning.
- Infrastructure Provider Integrations - Integrates with cloud provider APIs to retrieve system-level hardware statistics like CPU and IOPS.
- Database Access Controls - Provides utilities to manage database users and assign granular table-level permissions.
- Cloud Resource Monitoring - Retrieves system-level hardware statistics such as CPU usage and IOPS via cloud provider service integrations.
- Infrastructure Observability - Monitors cloud system metrics like CPU and IOPS alongside database health and replication lag.
- Replication Lag Metrics - Monitors the time delay between a primary database and its replicas to ensure data consistency.
- Growth Tracking - Tracks the growth of databases and schemas over time to assist with capacity planning.
- Database Tools - Insights and monitoring for PostgreSQL.
- Performance and Optimization - PostgreSQL performance insights and monitoring.
- Monitoring and Performance - Performance dashboard providing health checks and indexing suggestions.
