-- 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%'
ORDER BY query_start desc;
M. Bender, S. Michel, P. Triantafillou, G. Weikum, and C. Zimmer. Proceedings of the 28th annual international ACM SIGIR conference on Research and development in information retrieval - SIGIR \textquotesingle05, ACM Press, (2005)