Activity
-- pgMonitor Exporter (ccp_wal_activity)
SELECT
last_5_min_size_bytes,
(SELECT COALESCE(sum(size),0) FROM pg_catalog.pg_ls_waldir()) AS total_size_bytes
FROM
(SELECT COALESCE(sum(size),0) AS last_5_min_size_bytes
FROM pg_catalog.pg_ls_waldir()
WHERE modification > CURRENT_TIMESTAMP - '5 minutes'::interval) x
Current WAL LSN
SELECT pg_current_wal_lsn();
Last WAL Received/Replayed (Replication Target)
SELECT pg_last_wal_receive_lsn() last_received, pg_last_wal_replay_lsn() last_replayed