๐Ÿ”Œ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.

This will allow Datasentinel to directly fetch system statistics using PostgreSQL queries.

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

  • System information

  • CPU load

  • CPU usage

  • Memory usage

  • Network usage

  • Swap usage

  • I/Os statistics

  • File-systems usage

Last updated