system_stats
system_stats is a PostgreSQL extension that provides functions to access system level statistics that can be used for monitoring
Installation
To be installed in the internal database named postgres
For detailed installation instructions of the extension, please consult the GitHub repository https://github.com/EnterpriseDB/system_stats
You need to grant the role monitor_system_stats to the monitoring user.
Monitored metrics
When the system_stats extension is installed, Datasentinel (using the agentless method) starts gathering system metrics directly from PostgreSQL clusters at regular intervals. This is achieved by running SQL queries, which enables Datasentinel to collect detailed system metrics without needing a local agent on each server.
Metrics:
System information
CPU load
CPU usage
Memory usage
Network usage
Swap usage
I/Os statistics
File-systems usage
Last updated