🦊

Valentin Trinqué ValentinTrinque

🦊

Curious, committed, open-minded. Passionate by software development and science.

ValentinTrinque / processlist.sql

Created April 15, 2026 11:57 — forked from romuald/processlist.sql

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;