Postgresql active queries

select query, now() - state_change, usename, pid, state, * 
from pg_stat_activity 
where state != 'idle' 
order by now() - state_change desc;