9 lines
405 B
Plaintext
9 lines
405 B
Plaintext
\pset pager always
|
|
\pset null 'NULL'
|
|
\encoding latin1
|
|
\set PROMPT1 '%n@%M:%>%x %/# '
|
|
\set PROMPT2 ''
|
|
\timing on
|
|
\set qstats91 'SELECT usename, datname, substring(current_query, 1,100) || ''...'' As query FROM pg_stat_activity WHERE current_query != ''<IDLE>'';'
|
|
\set qstats92 'SELECT usename, datname, left(query,100) || ''...'' As query FROM pg_stat_activity WHERE state != ''idle'' ;'
|
|
\pset pager always |