SELECT client_addr, sum(1) numconns, sum(CASE WHEN state = 'active' THEN 1 ELSE 0 END) active, sum(CASE WHEN state = 'idle' THEN 1 ELSE 0 END) idle, sum(CASE WHEN state = 'idle in transaction' THEN 1 ELSE 0 END) idle_in_transaction, sum(CASE WHEN state = 'idle in transaction (aborted)' THEN 1 ELSE 0 END) aborted, sum(CASE WHEN state = 'fastpath function call' THEN 1 ELSE 0 END) fastpath, sum(CASE