Re: PostgreSQL 9.3: monitor read vs write activity

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: PostgreSQL 9.3: monitor read vs write activity
Дата
Msg-id CA+h6AhhbmjqzFqwDhCON-aft183rTBH9=BYnCXq-A8V96b3=pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 9.3: monitor read vs write activity  (jaime soler <jaime.soler@gmail.com>)
Ответы Re: PostgreSQL 9.3: monitor read vs write activity  (Sergey Arlashin <sergeyarl.maillist@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Fri, Feb 14, 2014 at 1:46 PM, jaime soler <jaime.soler@gmail.com> wrote:
El vie, 14-02-2014 a las 11:09 +0400, Sergey Arlashin escribió:
> Hi!
> I'd like to setup my monitoring system to monitor read vs. write activity of my postgresql database. What is the best way do do this?

There are many monitoring system that provide this metricts like nagios,
munin, zabixx,... most of them rely on
http://bucardo.org/wiki/Check_postgres
Check the wiki http://wiki.postgresql.org/wiki/Monitoring



+1 

You can also do post monitoring by enable the logging and later running an analyser like pgbadger.

Sample Report:
http://dalibo.github.io/pgbadger/demov5/2012/12/09/index.html
Download Link:
http://sourceforge.net/projects/pgbadger/

---
Regards,
Raghavendra
EnterpriseDB Corporation

 
> --
> Best regards,
> Sergey Arlashin
>




--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

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

Предыдущее
От: jaime soler
Дата:
Сообщение: Re: PostgreSQL 9.3: monitor read vs write activity
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Using BSD/OS with 8.1, 8.4 and 9.3