pg_proctab

pig build pkg pgnodemx;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pgnodemx;		# install via package name, for the active PG version
pig install pg_proctab;		# install by extension name, for the current active PG version

pig install pg_proctab -v 18;   # install for PG 18
pig install pg_proctab -v 17;   # install for PG 17
pig install pg_proctab -v 16;   # install for PG 16
pig install pg_proctab -v 15;   # install for PG 15
pig install pg_proctab -v 14;   # install for PG 14

CREATE EXTENSION pg_proctab;

-- All PostgreSQL process info
SELECT pid, comm, state, utime, stime, vsize, rss, reads, writes
FROM pg_proctab();

-- Join with pg_stat_activity for per-query resource usage
SELECT a.pid, a.query, p.utime, p.stime, p.vsize, p.rss
FROM pg_stat_activity a
JOIN pg_proctab() p ON a.pid = p.pid;

SELECT "user", nice, system, idle, iowait FROM pg_cputime();

SELECT load1, load5, load15, last_pid FROM pg_loadavg();

SELECT memused, memfree, memshared, membuffers, memcached,
       swapused, swapfree, swapcached
FROM pg_memusage();

SELECT devname, reads_completed, writes_completed,
       sectors_read, sectors_written
FROM pg_diskusage();