Re: Monitoring number of backends

On Tue, Oct 22, 2013 at 10:41 AM, andy <andy(at)squeakycode(dot)net> wrote:

> Hi all.
>
> My website is about to get a little more popular. I'm trying to add in
> some measurements to determine an upper limit of how many concurrent
> database connections I'm currently using.
>
> I've started running this:
>
> SELECT sum(numbackends) AS count, sum(xact_commit) as ttlcommit FROM
> pg_stat_database;
>
> Every 10 seconds or so. I don't think its what I want though. It seems
> way too small. I'm guessing that its not a measure of the previous 10
> seconds. Its a count of how many backends are in use at the exact moment I
> run the sql.
>
> Is there a cumulative count someplace?
>

You can pull it from the log files if you change postgres.conf to use:

log_connections = on
log_disconnections = on

Cheers,

Jeff