Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42246=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WIkYe-0004nZ-4S
 for pgsql-admin@arkaria.postgresql.org; Wed, 26 Feb 2014 19:54:20 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42246=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WIkYd-0000WR-5D
 for pgsql-admin@arkaria.postgresql.org; Wed, 26 Feb 2014 19:54:19 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sergeyarl.maillist@gmail.com>) id 1WIkYW-0000ME-1o
 for pgsql-admin@postgresql.org; Wed, 26 Feb 2014 19:54:12 +0000
Received: from mail-lb0-x236.google.com ([2a00:1450:4010:c04::236])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <sergeyarl.maillist@gmail.com>) id 1WIkYS-0003Oo-VX
 for pgsql-admin@postgresql.org; Wed, 26 Feb 2014 19:54:11 +0000
Received: by mail-lb0-f182.google.com with SMTP id n15so996858lbi.13
 for <pgsql-admin@postgresql.org>; Wed, 26 Feb 2014 11:54:07 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=content-type:mime-version:subject:from:in-reply-to:date:cc
 :message-id:references:to;
 bh=3Au13eJernqY3xvRJIQzWaj3+QHUdR4ByKv3zB7yijc=;
 b=WqawyslTK9tn5tT5HXENCB6EptZWnx3lweZ2F4r1t/AsNZTdSoJOvGrD45ZVvAVHaV
 z1+ss8nMgLm1WF4bFskpZMbQ1d9ceHZHv6sc7DI9nnZVp6BMmfDcYjVTqFIuXBZbwkJY
 aQmLnEXg4UYgKJsntqe7WOXaSRo4cAhESMNqsRLqdqQDNvFZwBNsx/LoFt8c2m0hgjpT
 druQjZTCgZlIHOEBNZKujUy9NNX1ieo3c+Dj8KBbVCRfomKo9cxJma1/52+gar/2xw8l
 96iOacBipL5cVZ3rIHGKPHp16bSSCPpcYGbDk0t310hVh6KHcNQ+SdCluP3AXtrWMpUB
 6ZLw==
X-Received: by 10.112.137.65 with SMTP id qg1mr3419411lbb.7.1393444447543;
 Wed, 26 Feb 2014 11:54:07 -0800 (PST)
Received: from [192.168.1.200] ([188.134.10.29])
 by mx.google.com with ESMTPSA id mk5sm3279981lac.6.2014.02.26.11.54.05
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Wed, 26 Feb 2014 11:54:06 -0800 (PST)
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_DC73C6E4-56FE-425F-A2B1-3215695C54F3"
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: PostgreSQL 9.3: monitor read vs write activity
From: Sergey Arlashin <sergeyarl.maillist@gmail.com>
In-Reply-To: 
 <CA+h6AhhbmjqzFqwDhCON-aft183rTBH9=BYnCXq-A8V96b3=pw@mail.gmail.com>
Date: Wed, 26 Feb 2014 23:54:04 +0400
Cc: jaime.soler@gmail.com,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Message-Id: <EF317C14-2DBC-4922-82B4-E3A938CE9D91@gmail.com>
References: <63373956-B1E4-452A-9FE7-30C4799D2994@gmail.com>
 <1392365804.16183.9.camel@turing>
 <CA+h6AhhbmjqzFqwDhCON-aft183rTBH9=BYnCXq-A8V96b3=pw@mail.gmail.com>
To: Raghavendra <raghavendra.rao@enterprisedb.com>
X-Mailer: Apple Mail (2.1510)
X-Pg-Spam-Score: -1.0 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--Apple-Mail=_DC73C6E4-56FE-425F-A2B1-3215695C54F3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=iso-8859-1

Thank you for your response and sorry for answering so late. Didn't have =
a chance to check it.=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

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



On Feb 14, 2014, at 12:23 PM, Raghavendra =
<raghavendra.rao@enterprisedb.com> wrote:

>=20
>=20
> 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=F3:
> > 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


--Apple-Mail=_DC73C6E4-56FE-425F-A2B1-3215695C54F3
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=iso-8859-1

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Diso-8859-1"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; =
"><div>Thank you for your response&nbsp;and sorry for answering so late. =
Didn't have a chance to check it.&nbsp;</div><div><br></div><div>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&nbsp;&nbsp;pg_stat_database,&nbsp;pg_stat_user_tables,&nbsp;pg_stat_a=
ctivity and so on.&nbsp;</div><div><br></div><div>Let me =
explain.&nbsp;</div><div>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.&nbsp;</div><div><br></div><div><br></div><div><div><br><div><d=
iv>On Feb 14, 2014, at 12:23 PM, Raghavendra &lt;<a =
href=3D"mailto:raghavendra.rao@enterprisedb.com">raghavendra.rao@enterpris=
edb.com</a>&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><blockquote type=3D"cite"><div =
dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:'trebuchet =
ms',sans-serif"><br></div><div class=3D"gmail_extra"><br><div =
class=3D"gmail_quote">On Fri, Feb 14, 2014 at 1:46 PM, jaime soler <span =
dir=3D"ltr">&lt;<a href=3D"mailto:jaime.soler@gmail.com" =
target=3D"_blank">jaime.soler@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class=3D"gmail_quote" style=3D"margin: 0px 0px 0px 0.8ex; =
border-left-width: 1px; border-left-color: rgb(204, 204, 204); =
border-left-style: solid; padding-left: 1ex; position: static; z-index: =
auto; ">El vie, 14-02-2014 a las 11:09 +0400, Sergey Arlashin =
escribi=F3:<br>


<div class=3D"">&gt; Hi!<br>
&gt; 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?<br>
<br>
</div>There are many monitoring system that provide this metricts like =
nagios,<br>
munin, zabixx,... most of them rely on<br>
<a href=3D"http://bucardo.org/wiki/Check_postgres" =
target=3D"_blank">http://bucardo.org/wiki/Check_postgres</a><br>
Check the wiki <a href=3D"http://wiki.postgresql.org/wiki/Monitoring" =
target=3D"_blank">http://wiki.postgresql.org/wiki/Monitoring</a><br>
<div class=3D""><div =
class=3D"h5"><br></div></div></blockquote><div><br></div><div><br></div><d=
iv><div class=3D"gmail_default" style=3D"font-family:'trebuchet =
ms',sans-serif">+1&nbsp;</div><div class=3D"gmail_default" =
style=3D"font-family:'trebuchet ms',sans-serif">

<br></div><div class=3D"gmail_default" style=3D"font-family:'trebuchet =
ms',sans-serif">You can also do post monitoring by enable the logging =
and later running an analyser like pgbadger.</div><div =
class=3D"gmail_default">

<br></div><div class=3D"gmail_default"><font face=3D"trebuchet ms, =
sans-serif">Sample Report:</font></div><div class=3D"gmail_default"><font =
face=3D"trebuchet ms, sans-serif"><a =
href=3D"http://dalibo.github.io/pgbadger/demov5/2012/12/09/index.html">htt=
p://dalibo.github.io/pgbadger/demov5/2012/12/09/index.html</a><br>

</font></div><div class=3D"gmail_default" style=3D"font-family:'trebuchet =
ms',sans-serif"></div><div class=3D"gmail_default" =
style=3D"font-family:'trebuchet ms',sans-serif">Download Link:</div><div =
class=3D"gmail_default" style=3D"font-family:'trebuchet ms',sans-serif">

<div class=3D"gmail_default" style=3D"font-family:arial"><font =
face=3D"trebuchet ms, sans-serif"><a =
href=3D"http://sourceforge.net/projects/pgbadger/">http://sourceforge.net/=
projects/pgbadger/</a></font><br></div><div><br></div>
</div>
<div><div dir=3D"ltr"><font face=3D"'trebuchet ms', =
sans-serif"><div>---</div><div>Regards,</div><div>Raghavendra</div><div>En=
terpriseDB Corporation</div><div>Blog:&nbsp;<a =
href=3D"http://raghavt.blogspot.com/" =
target=3D"_blank">http://raghavt.blogspot.com/</a></div>

</font></div></div><div class=3D"gmail_default" =
style=3D"font-family:'trebuchet =
ms',sans-serif"></div><br></div><div>&nbsp;</div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left=
-style:solid;padding-left:1ex">

<div class=3D""><div class=3D"h5">
&gt; --<br>
&gt; Best regards,<br>
&gt; Sergey Arlashin<br>
&gt;<br>
<br>
<br>
<br>
<br>
--<br>
Sent via pgsql-admin mailing list (<a =
href=3D"mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>)=
<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-admin" =
target=3D"_blank">http://www.postgresql.org/mailpref/pgsql-admin</a><br>
</div></div></blockquote></div><br></div></div>
</blockquote></div><br></div></div></body></html>=

--Apple-Mail=_DC73C6E4-56FE-425F-A2B1-3215695C54F3--