Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIwIU-0002Da-Lh for pgsql-admin@arkaria.postgresql.org; Thu, 27 Feb 2014 08:26:26 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WIwIU-0002ow-0m for pgsql-admin@arkaria.postgresql.org; Thu, 27 Feb 2014 08:26:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIwIS-0002op-R3 for pgsql-admin@postgresql.org; Thu, 27 Feb 2014 08:26:24 +0000 Received: from webmail.zone.eu ([217.146.65.70]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WIwIP-0000UU-4K for pgsql-admin@postgresql.org; Thu, 27 Feb 2014 08:26:24 +0000 Received: from webmail.zone.ee (webmail.zone.eu [IPv6:2a02:29e8:700:0:1::70]) by webmail.zone.eu (Postfix) with ESMTPA id C1FC62402C93; Thu, 27 Feb 2014 10:26:19 +0200 (EET) Received: from [195.222.11.180] (Authenticated sender: spoon@planet.ee) by webmail.zone.ee ([217.146.65.71]) with HTTP; Thu, 27 Feb 2014 10:26:19 +0200 (EET) From: "Viktor" To: "Sergey Arlashin" Cc: "pgsql-admin@postgresql.org" Subject: Re: PostgreSQL 9.3: monitor read vs write activity Date: Thu, 27 Feb 2014 10:26:19 +0200 References: <63373956-B1E4-452A-9FE7-30C4799D2994@gmail.com> <1392365804.16183.9.camel@turing> In-Reply-To: X-Mailer: DataZone Webmail/2.4 X-Priority: 3 Message-ID: <1393489579.2c60d6ed@webmail.zone.ee> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="--=_32a0d843a84b8b043d1dd27601109a5b" X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ----=_32a0d843a84b8b043d1dd27601109a5b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello, =20 You can check the table statistics with this SQL script for example: =20 = http://fmcgeough.wordpress.com/2013/07/10/what-the-hell-is-going-on-with-my= -postgresql-instance/ =20 I=C2=A0have changed it a little bit to suit my needs and I use it very = often. =20 =20 -- Best regards, Viktor =20 -------- Original Message -------- From: "Sergey Arlashin" To: "Raghavendra" Cc: "jaime.soler@gmail.com" , = "pgsql-admin@postgresql.org" Date: 26.02.2014 21:54:38 Subject: Re: [ADMIN] PostgreSQL 9.3: monitor read vs write activity =20 Thank you for your response and sorry for answering so late. Didn't have = a chance to check it.=20 =20 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.=20 =20 Let me explain.=20 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.=20 =20 =20 =20 On Feb 14, 2014, at 12:23 PM, Raghavendra = wrote: =20 >=20 >=20 > On Fri, Feb 14, 2014 at 1:46 PM, jaime soler = wrote: > El vie, 14-02-2014 a las 11:09 +0400, Sergey Arlashin escribi=C3=B3: > > 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? >=20 > 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 >=20 >=20 >=20 > +1=20 >=20 > You can also do post monitoring by enable the logging and later running = an analyser like pgbadger. >=20 > Sample Report: > http://dalibo.github.io/pgbadger/demov5/2012/12/09/index.html > Download Link: > http://sourceforge.net/projects/pgbadger/ >=20 > --- > Regards, > Raghavendra > EnterpriseDB Corporation > Blog: http://raghavt.blogspot.com/ >=20 >=20 > > -- > > Best regards, > > Sergey Arlashin > > >=20 >=20 >=20 >=20 > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > =20 ----=_32a0d843a84b8b043d1dd27601109a5b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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.maillist@gmail.com>
To: "Raghavendra" <raghavendra.rao@enterprisedb.com>
Cc: "jaime.soler@gmail.com" <jaime.soler@gmail.com>, = "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.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.rao@enterprise= db.com> wrote:

>
>
> 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=C3=B3:
> > 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/Che= ck_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/pr= ojects/pgbadger/
>
> ---
> Regards,
> Raghavendra
> EnterpriseDB Corporation
> Blog: http://raghavt.blogspot.com/
>
>
> > --
> > Best regards,
> > Sergey Arlashin
> >
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)<= br /> > To make changes to your subscription:
> http://www.postgres= ql.org/mailpref/pgsql-admin
>


----=_32a0d843a84b8b043d1dd27601109a5b--