Skip to content

Instantly share code, notes, and snippets.

@xxx

xxx/.psqlrc

Last active July 17, 2017 19:03
Show Gist options
  • Save xxx/4a460749f5f2d01019812d536ed42648 to your computer and use it in GitHub Desktop.
Save xxx/4a460749f5f2d01019812d536ed42648 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
.psqlrc
\set PROMPT1 '%[%033[33;1m%]%x%[%033[0m%]%[%033[1m%]%/%[%033[0m%]%R%# '
\timing
\pset linestyle unicode
\pset border 2
\set show_slow_queries 'SELECT (total_time / 1000 / 60) as total_minutes, (total_time/calls) as average_time, query FROM pg_stat_statements ORDER BY 1 DESC LIMIT 100;'
\x auto
\pset null '␀'
\set COMP_KEYWORD_CASE upper
\pset format wrapped
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment