SELECT
    datname,
    datid,
    pid AS pid,
    usename,
    client_addr,
    query AS query,
    state AS state,
    CASE WHEN client_port < 0 THEN
        0
    ELSE
        client_port
    END AS client_port,
    COALESCE(ROUND(EXTRACT(epoch FROM now() - query_start)), 0) AS seconds
FROM
    pg_stat_activity
WHERE (query_start IS NOT NULL
    AND (state NOT LIKE 'idle%'
        OR state IS NULL))
AND usename <> 'barman'
ORDER BY
    query_start,
    pid DESC;