system_stats
system_stats is a PostgreSQL extension that provides functions to access system level statistics that can be used for monitoring
Last updated
system_stats is a PostgreSQL extension that provides functions to access system level statistics that can be used for monitoring
Last updated
To be installed in the internal database named postgres
For detailed installation instructions of the extension, please consult the GitHub repository
You need to grant the role monitor_system_stats to the monitoring user.
When the system_stats extension is installed, Datasentinel (using the ) 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