pg_rusage

pg_rusage : Measure backend CPU usage between explicit reset and print calls

Overview

Packages

Source

pig build pkg pg_rusage;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION pg_rusage;

Usage

Sources:

• Official upstream README
• Official extension control file (pg_rusage.control)
• Official extension SQL (pg_rusage–1.0.sql)

pg_rusage — This module is a PostgreSQL extension that can enable CPU measurements, with one SQL function to enable the measurement and one to disable it. When disabling, the existing accumulated results will show up. Use it when collecting or interpreting the corresponding PostgreSQL statistics. Use the pinned upstream revision linked above as the API boundary and test it on the target PostgreSQL build.

Core Workflow

CREATE EXTENSION pg_rusage;

Install the extension in the intended database, run the smallest upstream example above when available, and verify the installed version and returned values before integrating it into application SQL.

Important Objects

• pg_rusage_print() is an extension function and returns void.
• pg_rusage_reset() is an extension function and returns void.

Requirements and Caveats

• The reviewed control file declares default version 1.0.
• The control file marks the extension as relocatable.
• Confirm privileges, supported PostgreSQL versions, upgrade behavior, and failure cases against the pinned source before production use.