Status information on active/idle Postgresql connections

connection_status.sql

SELECT
	datid,
	datname,
	pid,
	backend_type,
	application_name,
	--xact_start,
	query_start,
	state_change,
	--wait_event_type,
	wait_event,
	state,
	query,
	client_addr,
	--client_hostname,
	client_port,
	backend_start,
	--backend_xid,
	backend_xmin,
	usesysid,
	usename
FROM
	pg_catalog.pg_stat_activity;