# psql -c "SELECT (SELECT COUNT(*) FROM pg_stat_activity) AS total, COUNT(host(client_addr)) AS amount, format('%s%%', ((COUNT(host(client_addr))) * 100 / (SELECT COUNT(*) FROM pg_stat_activity))) AS share, client_addr FROM pg_stat_activity GROUP BY client_addr"

SELECT (
  SELECT COUNT(*)
  FROM pg_stat_activity
  ) AS total, COUNT(host(client_addr)) AS amount, format(
    '%s%%',
    (
      (
        COUNT(host(client_addr))) * 100 / (
          SELECT COUNT(*)
          FROM pg_stat_activity
        )
      )
    ) AS share, client_addr
FROM pg_stat_activity GROUP BY client_addr