On Tue, Oct 22, 2013 at 10:41 AM, andy <a...@squeakycode.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
