Matt Richter matthewmrichter

rgreenjr / postgres_queries_and_commands.sql

Last active May 14, 2025 00:29

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

marktheunissen / pedantically_commented_playbook.yml

Last active April 19, 2025 17:31 — forked from phred/pedantically_commented_playbook.yml

Insanely complete Ansible playbook, showing off all the options

This playbook has been removed as it is now very outdated.