-- JoeC read-only PostgreSQL reference. Review versions and query permissions.
-- Run with a restricted monitoring role; do not expose connection strings.
SELECT current_setting('server_version') AS server_version, pg_is_in_recovery() AS is_standby, clock_timestamp() AS sampled_at;
SELECT state, count(*) AS sessions FROM pg_stat_activity GROUP BY state ORDER BY sessions DESC;
SELECT datname, pg_size_pretty(pg_database_size(datname)) AS database_size
  FROM pg_database WHERE datallowconn ORDER BY pg_database_size(datname) DESC;
SELECT mode, granted, count(*) AS lock_count FROM pg_locks GROUP BY mode, granted ORDER BY lock_count DESC;
-- Primary-side sender state; empty result may be normal.
SELECT application_name, state, sync_state, sent_lsn, write_lsn, flush_lsn, replay_lsn FROM pg_stat_replication;
-- Never include SQL query text with sensitive parameters in shared reports.