Extended activity monitoring — enriches pg_stat_activity with per-backend memory usage, live temporary file bytes, and (PostgreSQL 18+) the current execution plan ID per backend.
Container resource visibility — reports CPU quota, memory limits, current memory usage, and CPU pressure for PostgreSQL running inside Docker, Kubernetes, OpenShift, or any cgroup-managed environment.
Wraparound risk estimation — tracks XID and MXID consumption rates and provides live ETAs to the aggressive-vacuum and wraparound limits.
Log capture into queryable views — records vacuum, analyze, temporary file, and checkpoint events into shared-memory ring buffers with parsed counters and timings available for real-time querying.
Requirements
PostgreSQL 15 or newer.
About pg_datasentinel
pg_datasentinel is an open source PostgreSQL extension under the 3-Clause BSD license that adds deep observability capabilities.
The extension is developed and maintained by Christophe REVEILLERE at DATASENTINEL. If you need more information, please contact us.
