{"repo":"datasentinel/pg_datasentinel","free":true,"listed":false,"github":"https://github.com/datasentinel/pg_datasentinel","clone":"git clone https://github.com/datasentinel/pg_datasentinel.git","description":"Observability and activity monitoring extension","language":"C","stars":17,"topics":["observability","postgresql"],"license":"BSD-3-Clause","category":"analytics","readme_excerpt":"pg datasentinel pg datasentinel is a PostgreSQL extension that adds observability views. It enriches pg stat activity with per-backend memory and temporary file usage (linux only), captures vacuum, analyze, temporary file, and checkpoint events into shared-memory ring buffers, estimates XID and MXID wraparound risk with rate-based ETAs, and reports container CPU and memory limits via cgroups. It must be loaded via shared preload libraries . --- Features - ds stat activity — extends pg stat activity with real-time memory usage (resident set size from /proc ), live temporary file bytes, and (PostgreSQL 18+) the current plan ID for each backend. - ds container resources — single-row view that reports cgroup v1/v2 CPU quota, memory hard limit, current memory usage, and CPU pressure (PSI avg60, cgroup v2 only) for the PostgreSQL process. Useful when PostgreSQL runs inside a container (Docker, Kubernetes, OpenShift) where resource limits are enforced via cgroups. - ds wraparound risk — single-row view that samples XID and MXID at each checkpoint (at most once per hour) and provides live distances to the aggressive-vacuum and wraparound limits for both XID and MXID, plus rate-based ETAs that reflect whichever counter is closer to danger. - ds vacuum activity — captures autovacuum LOG messages and manual VACUUM INFO messages in a shared-memory ring buffer; parses page/tuple counters, CPU timings, whether the run was aggressive, and whether it was triggered manually. - ds analyze acti","default_branch":null,"files":null,"tree":[],"storefront":"/r/datasentinel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/datasentinel/pg_datasentinel/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}