Re: Average connections

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Average connections
Дата
Msg-id 20090610085214.19ad0776.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на Average connections  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Ответы Re: Average connections  (Pedro Doria Meunier <pdoria@netmadeira.com>)
Список pgsql-general
In response to Pedro Doria Meunier <pdoria@netmadeira.com>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi all
>
> I've googled for an answer but couldn't find one.
> Is there anyway to monitor the average connections to a database?
>
> Thank you in advance for any insights.

The pg_stat_activity table holds 1 row for each connection with information
on what that connection is doing.

It wouldn't be very difficult to write a passthrough script for something
like MRTG to graph this data.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/

В списке pgsql-general по дате отправления:

Предыдущее
От: Pedro Doria Meunier
Дата:
Сообщение: Average connections
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Upgrade from Postgres 8.2.4 to 8.3.5