Christoph Giesel christophlsa

christophlsa / postgres_queries_and_commands.sql

Created February 19, 2018 15:39 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

christophlsa / damazon.py

Last active August 29, 2015 14:09 — forked from zakx/damazon.py

	#!/usr/bin/python

	# setup: pip install requests beautifulsoup4

	from decimal import Decimal
	import requests
	from bs4 import BeautifulSoup
	import sys
	import getpass

christophlsa / webserver.c

Created November 16, 2011 20:42

homework for the study