get number and names of processes connected to postgresql

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: get number and names of processes connected to postgresql
Date: 2011-09-23 10:34:12
Message-ID: CAJY59_gKcbXcpPVZqpkLB742N_oNLtFT95A5Tk17HvTo40Yx3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Basically, I got bunch of local processes connecting to postgresql,
need to aggregate some sort of report about number of connections and
its origin every so often.
pg version is 8.3

Any ideas if there's tools to gather that info on linux ?
Netstat is the only one I know, but I have to parse/awk its output to
get something meaningful out of it.

Ideas are welcomed.

--
GJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-09-23 10:39:33 Re: looking for a faster way to do that
Previous Message Ingmar Brouns 2011-09-23 10:31:49 Re: Query performs badly with materialize node