From: Viktor <spoon@planet.ee>
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL 9.3: monitor read vs write activity
Date: Thu, 27 Feb 2014 10:26:19 +0200
Message-ID: <1393489579.2c60d6ed@webmail.zone.ee> (raw)
In-Reply-To: <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>
<EF317C14-2DBC-4922-82B4-E3A938CE9D91@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@enterprisedb.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ó:
> > 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: spoon@planet.ee, sergeyarl.maillist@gmail.com
Subject: Re: PostgreSQL 9.3: monitor read vs write activity
In-Reply-To: <1393489579.2c60d6ed@webmail.zone.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox