Common SQL

Get Process Start Time

SELECT pg_postmaster_start_time();

Show Config File

SHOW config_file;

Show Max Connections

SHOW max_connections;

Get Total Activity Connections

SELECT COUNT(*) AS total_connections FROM pg_stat_activity;

Activity Connections Stats

SELECT
  usename,
  datname,
  client_addr,
  application_name,
  state,
  COUNT(*) AS connections
FROM pg_stat_activity
GROUP BY 1, 2, 3, 4, 5
ORDER BY connections DESC;

Kill IDLE Connections

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE usename = 'xxx'
  AND state = 'idle'
  AND pid <> pg_backend_pid();  -- 排除当前连接