PostgresTips.md

Postres Tips on Terminal

Show running queries (ala Mysql processlist)

SELECT pid,datname,usename,application_name,client_hostname,client_port,backend_start,query_start,query 
FROM pg_stat_activity 
WHERE state <> 'idle' 
AND pid<>pg_backend_pid();

Don't truncate query (need restart postgres)

ALTER SYSTEM SET track_activity_query_size = 16384;