pgSentinel: Professional pgbalancer Management Platform
Enterprise-Grade Web-Based Monitoring with Real-Time Metrics & Advanced Analytics
pgSentinel DashboardReal-Time Monitoring
$ docker-compose up -d
✅ Backend APIhttp://localhost:8000
✅ Dashboardhttp://localhost:3000
✅ Grafanahttp://localhost:3001
✅ Prometheushttp://localhost:9090
◆ Real-Time Metrics:
• CPU Usage: 12.5%
• Memory: 45.2%
• Active Connections: 127
• Pool Utilization: 67.8%
• Query Throughput: 1,245 QPS
✓ All services running healthy • 8 containers operational
Real-Time MonitoringPrometheus IntegrationGrafana Dashboardspg_stat_insightsREST APIWebSocket LiveProduction ReadyDocker Optimized
Complete Monitoring Stack

Why pgSentinel

Real-Time Web Dashboard

Interactive Next.js 14 dashboard with React 18, TypeScript, Tailwind CSS, and Recharts. Live WebSocket updates every 5 seconds for instant visibility.

Prometheus Integration

30+ custom metrics including active connections, CPU/memory usage, pool utilization, query throughput, and backend health with full PromQL support.

Grafana Visualization

2 professional dashboards with 22 panels covering system metrics, pg_stat_insights data, and custom analytics with configurable time ranges.

pg_stat_insights Analytics

Deep PostgreSQL performance analysis including slow queries, cache hit ratios, table bloat, index usage, replication lag, and optimization recommendations.

FastAPI Backend

High-performance Python 3.12 backend with 25+ RESTful endpoints, WebSocket support, Pydantic validation, and asyncpg for PostgreSQL connectivity.

Alert Management

Integrated Alertmanager with configurable routing, grouping, silencing, and notification channels for proactive incident response.

Docker Orchestration

8-service architecture with backend, frontend, website, PostgreSQL, Redis, Prometheus, Grafana, and Alertmanager all orchestrated via Docker Compose.

Production Ready

Complete with health checks, automatic restarts, volume persistence, network isolation, and comprehensive logging across all services.

Depth

Feature Matrix

ComponentTechnologyPurposeKey Features
Frontend DashboardNext.js 14, React 18, TypeScriptReal-time monitoring interfaceLive metrics, WebSocket updates, beautiful UI
Backend APIFastAPI, Python 3.12, asyncpgAPI server & data aggregation25+ endpoints, WebSocket, Pydantic validation
PrometheusPrometheus 2.xMetrics collection & storage30+ custom metrics, PromQL, alerting
GrafanaGrafana 10.xProfessional visualization2 dashboards, 22 panels, custom queries
pg_stat_insightsPostgreSQL extensionsDeep performance analyticsQuery stats, table/index analysis, recommendations
Redis CacheRedis 7Session & data cachingFast retrieval, session management
AlertmanagerPrometheus AlertmanagerAlert routing & notificationRouting, grouping, silencing
Node ExporterPrometheus Node ExporterSystem metrics collectionCPU, memory, disk, network stats