psqlrc

\set AUTOCOMMIT off
\set PROMPT1 '%[%033[33;1m%]%x%[%033[0m%]%[%033[1m%]%/%[%033[0m%]%R%# '
\pset border 2
\timing on
\set queries  'select current_timestamp - query_start as runtime,pid,datname,usename,query from pg_stat_activity where query != \'<IDLE>\' order by 1 desc; '
\set backends 'SELECT datname, numbackends FROM pg_catalog.pg_stat_database;'
\set r 'rollback;'
\set ON_ERROR_STOP true