Monitoring number of backends
От | andy |
---|---|
Тема | Monitoring number of backends |
Дата | |
Msg-id | 5266B8E6.1080500@squeakycode.net обсуждение исходный текст |
Ответы |
Re: Monitoring number of backends
Re: Monitoring number of backends Re: Monitoring number of backends |
Список | pgsql-general |
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? Thanks for your time, -Andy
В списке pgsql-general по дате отправления: