How to List Active Connections on PostgreSQL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

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