.psqlrc

-- Don't display the "helpful" message on startup.
\set QUIET 1

-- Show how long each query takes to execute
\timing

-- Use best available output format
\x auto

-- Verbose error reports
\set VERBOSITY verbose

-- If a command is run more than once in a row,
-- only store it once in the history
\set HISTCONTROL ignoredups
\set COMP_KEYWORD_CASE upper

-- Use system pager for long outputs
\pset pager on

-- By default, NULL displays as an empty space. Is it actually an empty
-- string, or is it null? This makes that distinction visible
\pset null '[NULL]'

-- An alias to show queries stats
\set stats '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 asc;'

\unset QUIET