PMP4PG
Proactive Monitoring Platform for PostgreSQL
A complete, Oracle OEM-inspired monitoring platform for your PostgreSQL infrastructure — built for DBAs and developers who need real visibility.
Why PMP4PG?
Managing PostgreSQL in production without the right tools means flying blind. PMP4PG brings the power of Oracle's OEM and AWR methodology to the PostgreSQL world — giving you real-time activity analysis, historical snapshots, proactive workload reports, and long-term trends, all in a single unified platform.
Whether you're troubleshooting a slow query at 3 AM or planning next quarter's capacity, PMP4PG gives you the data you need at the right level of granularity.
Key Features
🟢 Real-Time Activity — ASH Viewer
Monitor active sessions, top SQL, wait events and lock contention as they happen. Inspired by Oracle's Active Session History (ASH), with sliding time windows from 15 minutes up to 8 hours and a fully interactive timeline.
📊 Proactive Analysis — AWR Viewer
Generate detailed workload reports between any two snapshots — Load Profile, Time Model, Top SQL, Wait Events, Bloat Analysis, Vacuum Stats, WAL activity — exported as standalone HTML reports, just like Oracle AWR.
📈 Long-Term Trends
Visualize how your PostgreSQL instances evolve over days, weeks and months. Track database size growth, throughput, WAL generation and more. Essential for capacity planning.
🖥️ Global Dashboard
A single-pane-of-glass view of all your monitored PostgreSQL servers — statuses, KPIs, active alerts and environment breakdown at a glance.
🤖 Lightweight Go Agent
A small, self-contained agent written in Go deployed on each monitored server. It collects metrics from PostgreSQL internals (pg_stat_activity, pg_stat_statements, pg_stat_database...) and sends them to the central platform with minimal overhead.
🔔 Alerts
Stay informed of critical events across your PostgreSQL fleet with a centralized alert list.
Architecture at a Glance
┌─────────────────────────────────────────────────────────┐
│ PostgreSQL Servers │
│ ┌──────────┐ ┌──────────┐ ┌──────────┐ │
│ │ PG Agent │ │ PG Agent │ │ PG Agent │ ... │
│ │ (Go) │ │ (Go) │ │ (Go) │ │
│ └────┬─────┘ └────┬─────┘ └────┬─────┘ │
└───────┼──────────────┼──────────────┼─────────────────-┘
│ │ │ (REST API / HTTPS)
▼ ▼ ▼
┌───────────────────────────────────────────────────────-─┐
│ PMP4PG Backend (Java / Spring Boot) │
│ Metrics ingestion · AWR Snapshots · REST API │
└───────────────────────────┬─────────────────────────────┘
│
┌─────────────┴──────────────┐
│ │
▼ ▼
┌─────────────────────────┐ ┌───────────────────────────┐
│ Repository │ │ PMP4PG Frontend │
│ (PostgreSQL + │ │ (Angular / PrimeNG) │
│ TimescaleDB) │ │ pmp.data-resilience.fr │
└─────────────────────────┘ └───────────────────────────┘
Who is it for?
| Profile | How PMP4PG helps |
|---|---|
| PostgreSQL DBA | Deep workload analysis, AWR reports, real-time session monitoring |
| DevOps / SRE | Fleet visibility, agent deployment, alert management |
| Database Architect | Capacity planning with long-term trends and size tracking |
| Developer | Identify slow queries and wait events in development environments |
Get Started
Ready to deploy PMP4PG in your environment?
Version
Current stable release: v1.0.0
See the full Changelog → for release history.
PMP4PG is developed and maintained by Data Resilience.