pg_track_settings

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

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

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

CREATE EXTENSION pg_track_settings;

SELECT pg_track_settings_snapshot();

-- All settings at a specific time
SELECT * FROM pg_track_settings('2024-01-15 10:00:00');

-- All overloaded (per-role/database) settings at a specific time
SELECT * FROM pg_track_db_role_settings('2024-01-15 10:00:00');

-- Find what changed in the last hour
SELECT * FROM pg_track_settings_diff(now() - interval '1 hour', now());

-- Compare overloaded settings
SELECT * FROM pg_track_db_role_settings_diff(now() - interval '1 hour', now());

-- History of a specific setting
SELECT * FROM pg_track_settings_log('work_mem');

-- History of an overloaded setting
SELECT * FROM pg_track_db_role_settings_log('work_mem');

-- PostgreSQL restart history
SELECT * FROM pg_reboot;

SELECT pg_track_settings_reset();