postgres

some output formatting options

postgresql pager off

\pset pager 0

postgres psql print only data

\t

postgres aling off

\a 0

postgresql pg_stat_statements longest query

SELECT query, total_time, calls, rows FROM  pg_stat_statements ORDER BY total_time DESC LIMIT 1;

postgres connections

SELECT pid, datname, usename, application_name,client_hostname, client_port, backend_start, query_start,query, state FROM pg_stat_activity 
-- WHERE state = 'active'
;

install client on debian

export DEBIAN_FRONTEND=noninteractive && apt update && apt -y --no-install-recommends install postgresql-client