PgHero
1-Click installation template for PgHero on Easypanel
Description
PgHero is a powerful performance dashboard for PostgreSQL databases that provides real-time insights into query performance, slow queries, index usage, and database health metrics. It helps database administrators and developers optimize their PostgreSQL databases by identifying performance bottlenecks, unused indexes, and query patterns. The dashboard features an intuitive web interface with detailed analytics and recommendations for database optimization.
Benefits
- Performance Monitoring: Monitor PostgreSQL database performance in real-time with detailed metrics on query execution times, database connections, and resource usage.
- Query Analysis: Identify slow queries, analyze query patterns, and get recommendations for optimizing database performance and query efficiency.
- Index Optimization: Discover unused indexes, missing indexes, and get suggestions for index optimization to improve database performance.
- Easy Setup: Simple deployment with automatic PostgreSQL database provisioning and seamless integration with existing database infrastructure.
Features
- Real-time Dashboard: Comprehensive web-based dashboard showing live database metrics, performance graphs, and health indicators.
- Slow Query Detection: Automatically detect and analyze slow queries with detailed execution plans and optimization suggestions.
- Index Monitoring: Monitor index usage, detect unused indexes, and identify missing indexes that could improve query performance.
- Connection Monitoring: Track database connections, connection pools, and identify potential connection bottlenecks or issues.
Links
Options
| Name | Description | Required | Default Value |
|---|---|---|---|
| App Service Name | - | yes | pghero |
| App Service Image | PgHero Docker image | yes | ankane/pghero:v3.7.0 |
Screenshots
Change Log
- 2025-06-25 – Initial Template Release