Mike Bardsley mic2100

Senior developer with over 19 years experience

romuald / processlist.sql

Last active December 19, 2025 11:12

Show PostgreSQL current (running) process list;

	SELECT user, pid, client_addr, waiting, query, query_start, NOW() - query_start AS elapsed
	FROM pg_stat_activity
	WHERE query != '<IDLE>'
	-- AND EXTRACT(EPOCH FROM (NOW() - query_start)) > 1
	ORDER BY elapsed DESC;