Re: How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

Поиск

Список

Период

Сортировка

От	hubert depesz lubaczewski
Тема	Re: How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?
Дата	7 июля 2006 г. 04:37:52
Msg-id	9e4684ce0607070037g2a66d830sabc77aa2d3116229@mail.gmail.com обсуждение исходный текст
Ответ на	Re: How are ppl monitoring PostgreSQL ... ? What is being monitored ... ? (<ogjunk-pgjedan@yahoo.com>)
Ответы	Re: How are ppl monitoring PostgreSQL ... ? What is being
Список	pgsql-admin

Дерево обсуждения

On 7/7/06, ogjunk-pgjedan@yahoo.com <ogjunk-pgjedan@yahoo.com> wrote:

Interesting, Hubert.
Where/how do you get the data for:
- number of transactions per second

periodically (every 5 minutes) i do:
select sum(xact_commit) + sum(xact_rollback) from pg_stat_database
and then just check against previous value, and calculate "per/second". this is actually handled nicely by mrtg itself.

- duration of longest query

select * from pg_stat_activity where current_query !~ '<IDLE>' order by query_start asc limit 1;
this has some problems though, but are more or less easily avoidable.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?