theonlyway

import botocore.waiter
import botocore.session


session = botocore.session.get_session()
client = session.create_client('ec2')

VOLUME_ID = ... # e.g. 'vol-049df61146c4d7901'
INSTANCE_ID = ...  # e.g. 'i-1234567890abcdef0'
DEVICE = ... # e.g. '/dev/xvdba'

theonlyway

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

theonlyway

Useful PostgreSQL Queries & Commands

All sizes in MB, change /1024/1024 to /1024/1024/1024 for GB.

Databases sizes

Without system databases

select
datname as database,
(pg_database_size(datname)/1024/1024) as size