pg_wait_sampling

pig repo add pgdg -u    # add pgdg repo and update cache

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

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

shared_preload_libraries = 'pg_wait_sampling';

CREATE EXTENSION pg_wait_sampling;

SELECT * FROM pg_wait_sampling_current;

SELECT * FROM pg_wait_sampling_history;

SELECT * FROM pg_wait_sampling_profile;

SELECT * FROM pg_wait_sampling_get_current(12345);

SELECT pg_wait_sampling_reset_profile();

SELECT event_type, event, count
FROM pg_wait_sampling_profile
ORDER BY count DESC
LIMIT 10;