Show open connections to databases in a brief format conducive to CLI usage

pgactivity

SELECT procpid as pid,
         usename as user,
         datname as db,
  application_name as app, waiting as wait, current_query as query
FROM pg_stat_activity
WHERE datname <> 'postgres';