ListenLoop listenloop

rgreenjr / postgres_queries_and_commands.sql

Last active December 5, 2025 09:56

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%'

jaydson / gist:1780598

Created February 9, 2012 15:11

How to detect a click event on a cross domain iframe

	var myConfObj = {
	iframeMouseOver : false
	}
	window.addEventListener('blur',function(){
	if(myConfObj.iframeMouseOver){
	console.log('Wow! Iframe Click!');
	}
	});

	document.getElementById('YOUR_CONTAINER_ID').addEventListener('mouseover',function(){