pgmeminfo

pig build pkg pgmeminfo;		# build rpm/deb

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

pig install pgmeminfo;		# install via package name, for the active PG version

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

CREATE EXTENSION pgmeminfo;

-- Show overall memory info
SELECT * FROM pgmeminfo();

-- Show cumulative memory context sizes
SELECT * FROM pgmeminfo_contexts();

-- Show memory contexts to a specific depth
SELECT * FROM pgmeminfo_contexts(deep => 1);

-- Show all contexts without accumulation
SELECT * FROM pgmeminfo_contexts(deep => -1, accum_mode => 'off');