Some useful queries

queries.sql

SELECT nspname || '.' || relname AS "relation",
			 pg_size_pretty(pg_relation_size(C.oid)) AS "size"
	FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
	WHERE nspname NOT IN ('pg_catalog', 'information_schema')
	ORDER BY pg_relation_size(C.oid) DESC
	LIMIT 200 -- bigtables;

SELECT
	pg_stat_activity.pid,
	pg_class.relname,
	pg_locks.transactionid,
	pg_locks.granted,
	age(now(),pg_stat_activity.query_start) AS "age",
	pg_locks.mode,
	pg_stat_activity.query
	FROM pg_stat_activity,pg_locks left
	OUTER JOIN pg_class
ON (pg_locks.relation = pg_class.oid)
	WHERE pg_stat_activity.query <> '<insufficient privilege>'
	AND pg_locks.pid = pg_stat_activity.pid
AND pg_stat_activity.pid <> pg_backend_pid()
	ORDER BY age DESC LIMIT 800 -- actmon;