# Deploy PgHero with Easypanel

URL: /templates/pghero

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.

## Configuration

- `appServiceName` (App Service Name, required): pghero

- `appServiceImage` (App Service Image, required): ankane/pghero:v3.8.0 — PgHero Docker image

## Services

- pghero-db: postgres

- pghero: app (ankane/pghero:v3.8.0)

## Resources

- [GitHub](https://github.com/ankane/pghero)

- [Documentation](https://github.com/ankane/pghero#readme)

- [Template source](https://github.com/easypanel-io/templates/tree/main/templates/pghero)