Created
March 26, 2019 16:32
-
-
Save mtunjic/08fb74a4ffa0ff1c91d5927723e4a455 to your computer and use it in GitHub Desktop.
psql environment
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
\pset null 'NULL' | |
\encoding latin1 | |
\set PROMPT1 '%n@%M:%>%x %/# ' | |
\pset pager always | |
\timing on | |
\set qstats92 ' | |
SELECT usename, datname, left(query,100) || ''...'' As query | |
FROM pg_stat_activity WHERE state != ''idle'' ; | |
' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment