Features
PG Pilot provides comprehensive PostgreSQL monitoring with 9 core feature areas.
Query Monitoring
Real-time query performance monitoring using pg_stat_statements. Track execution times, call counts, and buffer usage to identify slow queries.
- Query execution statistics
- Performance trends over time
- Cache hit ratio analysis
- Top slow queries
Index Health
Comprehensive index monitoring to find unused, duplicate, and bloated indexes. Optimize storage and write performance with actionable insights.
- Unused index detection
- Duplicate index identification
- Index size tracking
- Index validity monitoring
Table Monitoring
Comprehensive table health monitoring including size tracking, write activity, and bloat detection.
- Table size and growth
- Write activity tracking
- Sequential scan detection
- Dead tuple monitoring
Vacuum Management
Monitor vacuum operations and prevent transaction ID wraparound. Track autovacuum progress and identify tables needing maintenance.
- Real-time vacuum progress
- Autovacuum activity tracking
- XID wraparound prevention
- Table freeze age monitoring
Replication Monitoring
Monitor replication slots and streaming replication health. Track lag, WAL retention, and slot status to ensure replica reliability.
- Replication slot monitoring
- Lag measurement in bytes
- WAL status tracking
- Inactive slot detection
Connection Management
Real-time connection monitoring with state tracking, blocking detection, and connection pool usage analysis.
- Connection state tracking
- Blocking chain detection
- Long-running query alerts
- Connection pool usage
Configuration Management
Monitor PostgreSQL configuration settings and detect dangerous or suboptimal configurations with severity-based issue tracking.
- Configuration issue detection
- Severity-based categorization
- Extension monitoring
- Modified settings tracking
Schema Monitoring
Schema-level aggregation and monitoring for multi-tenant or complex database architectures.
- Schema size aggregation
- Table and index counts
- Health issue tracking per schema
Dashboard
At-a-glance view of database health with real-time metrics, performance charts, and quick access to issues.
- Real-time query metrics
- Performance trend charts
- Top slow queries
- Index health summary