🔌system_stats
system_stats is a PostgreSQL extension that provides functions to access system level statistics that can be used for monitoring
This extension is OPTIONAL and should be considered solely when you decide to employ the Agentless approach for monitoring your PostgreSQL instances.
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.
With this setup, you can browse and analyze these metrics with the same level of precision and granularity as you would expect if a local agent were installed. Refer to Cluster & System Metrics for more details.
Metrics:
System information
CPU load
CPU usage
Memory usage
Network usage
Swap usage
I/Os statistics
File-systems usage
Last updated