system_stats
EnterpriseDB system statistics for PostgreSQL
Repository
EnterpriseDB/system_stats
https://github.com/EnterpriseDB/system_stats
Source
system_stats-3.2.tar.gz
system_stats-3.2.tar.gz
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
system_stats | 3.2 | STAT | PostgreSQL | C |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 6420 | system_stats | No | Yes | No | Yes | No | Yes | - |
| Related | pgnodemx pg_proctab pgmeminfo pgfincore pg_wait_sampling pg_buffercache pg_background pg_cooldown |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | MIXED | 3.2 | 1817161514 | system_stats | - |
| RPM | PGDG | 3.2 | 1817161514 | system_stats_$v | - |
| DEB | PIGSTY | 3.2 | 1817161514 | postgresql-$v-system-stats | - |
Build
You can build the DEB packages for system_stats using pig build:
pig build pkg system_stats # build DEB packages
Install
You can install system_stats directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install system_stats; # Install for current active PG version
pig ext install -y system_stats -v 18 # PG 18
pig ext install -y system_stats -v 17 # PG 17
pig ext install -y system_stats -v 16 # PG 16
pig ext install -y system_stats -v 15 # PG 15
pig ext install -y system_stats -v 14 # PG 14
dnf install -y system_stats_18 # PG 18
dnf install -y system_stats_17 # PG 17
dnf install -y system_stats_16 # PG 16
dnf install -y system_stats_15 # PG 15
dnf install -y system_stats_14 # PG 14
apt install -y postgresql-18-system-stats # PG 18
apt install -y postgresql-17-system-stats # PG 17
apt install -y postgresql-16-system-stats # PG 16
apt install -y postgresql-15-system-stats # PG 15
apt install -y postgresql-14-system-stats # PG 14
Create Extension:
CREATE EXTENSION system_stats;
Usage
system_stats provides SQL functions to access OS-level statistics for monitoring. Supports Linux, macOS, and Windows.
Functions
-- Operating system info (name, version, hostname, uptime, etc.)
SELECT * FROM pg_sys_os_info();
-- CPU info (vendor, model, cores, clock speed, cache sizes)
SELECT * FROM pg_sys_cpu_info();
-- CPU usage (user, system, idle, iowait percentages)
SELECT * FROM pg_sys_cpu_usage_info();
-- Memory info (total, used, free, swap, cache in bytes)
SELECT * FROM pg_sys_memory_info();
-- Disk I/O analysis (reads, writes, bytes, time per device)
SELECT * FROM pg_sys_io_analysis_info();
-- Disk info (filesystem, mount point, total/used/available space)
SELECT * FROM pg_sys_disk_info();
-- Load average (1, 5, 10, 15 minute intervals)
SELECT * FROM pg_sys_load_avg_info();
-- Process info (total, running, sleeping, stopped, zombie counts)
SELECT * FROM pg_sys_process_info();
-- Network info (interface, IP, bytes/packets sent/received, errors)
SELECT * FROM pg_sys_network_info();
-- Per-process CPU and memory usage
SELECT * FROM pg_sys_cpu_memory_by_process();
Security
Access is restricted to superusers and members of the monitor_system_stats role:
-- Grant access to a monitoring user
GRANT monitor_system_stats TO nagios;
-- Or grant per-function to pg_monitor
GRANT EXECUTE ON FUNCTION pg_sys_os_info() TO pg_monitor;
Example: System Overview
SELECT * FROM pg_sys_load_avg_info(); -- load averages
SELECT memfree, memused, swapfree FROM pg_sys_memory_info(); -- memory
SELECT * FROM pg_sys_cpu_usage_info(); -- CPU usage breakdown
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.