eznj

"The better we get at getting better, the faster we will get better." - Douglas Engelbart

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

mrdoob / gist:1326080

Created October 30, 2011 16:25

modified glview.c

	/*
	* This file is part of the OpenKinect Project. http://www.openkinect.org
	*
	* Copyright (c) 2010 individual OpenKinect contributors. See the CONTRIB file
	* for details.
	*
	* This code is licensed to you under the terms of the Apache License, version
	* 2.0, or, at your option, the terms of the GNU General Public License,
	* version 2.0. See the APACHE20 and GPL2 files for the text of the licenses,
	* or the following URLs:

mrdoob / gist:1325393

Created October 30, 2011 02:48

ffmpeg: recording the screen.

ffmpeg -f x11grab -b 1M -bt 2M -r 30 -s 512x512 -i :0.0+1,53 -an kinect.webm