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