Re: PostgreSQL 9.3: monitor read vs write activity

On Fri, Feb 14, 2014 at 1:46 PM, jaime soler <jaime(dot)soler(at)gmail(dot)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
Blog: http://raghavt.blogspot.com/

> > --
> > Best regards,
> > Sergey Arlashin
> >
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>