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.

// example
GRANT monitor_system_stats to datasentinel;

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