Re: PostgreSQL 9.3: monitor read vs write activity

Hello,

You can check the table statistics with this SQL script for example:

http://fmcgeough.wordpress.com/2013/07/10/what-the-hell-is-going-on-with-my-postgresql-instance/

I have changed it a little bit to suit my needs and I use it very often.


--
Best regards,
Viktor

-------- Original Message --------
From: "Sergey Arlashin" <sergeyarl(dot)maillist(at)gmail(dot)com>
To: "Raghavendra" <raghavendra(dot)rao(at)enterprisedb(dot)com>
Cc: "jaime(dot)soler(at)gmail(dot)com" <jaime(dot)soler(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Date: 26.02.2014 21:54:38
Subject: Re: [ADMIN] PostgreSQL 9.3: monitor read vs write activity

Thank you for your response and sorry for answering so late. Didn't have a chance to check it.

But I cannot figure out how I can measure read vs write activity of my postgresql database with the help of "check_postgres"? I haven't seen anything related to it in "check_postgres --help" output. Moreover it seems I can get all the data that check_postgres provides simply by querying postgresql system tables like pg_stat_database, pg_stat_user_tables, pg_stat_activity and so on.

Let me explain.
When I used MySQL I was able to measure read vs write activity by counting the number of selects vs inserts/updates/deletes etc. But I cannot find anything similar in PostgreSQL.



On Feb 14, 2014, at 12:23 PM, Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

>
>
> 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
>