pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 9.3: monitor read vs write activity
6+ messages / 5 participants
[nested] [flat]
* PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-14 07:09 Sergey Arlashin <sergeyarl.maillist@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sergey Arlashin @ 2014-02-14 07:09 UTC (permalink / raw)
To: pgsql-admin
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?
--
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-14 08:16 jaime soler <jaime.soler@gmail.com>
parent: Sergey Arlashin <sergeyarl.maillist@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: jaime soler @ 2014-02-14 08:16 UTC (permalink / raw)
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>; +Cc: pgsql-admin
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
> --
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-14 08:23 Raghavendra <raghavendra.rao@enterprisedb.com>
parent: jaime soler <jaime.soler@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Raghavendra @ 2014-02-14 08:23 UTC (permalink / raw)
To: jaime.soler@gmail.com; +Cc: Sergey Arlashin <sergeyarl.maillist@gmail.com>; pgsql-admin
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-26 19:54 Sergey Arlashin <sergeyarl.maillist@gmail.com>
parent: Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 2 replies; 6+ messages in thread
From: Sergey Arlashin @ 2014-02-26 19:54 UTC (permalink / raw)
To: Raghavendra <raghavendra.rao@enterprisedb.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-27 03:15 Venkata Balaji Nagothi <vbnpgc@gmail.com>
parent: Sergey Arlashin <sergeyarl.maillist@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Venkata Balaji Nagothi @ 2014-02-27 03:15 UTC (permalink / raw)
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>; +Cc: Raghavendra <raghavendra.rao@enterprisedb.com>; pgsql-admin
On Thu, Feb 27, 2014 at 6:54 AM, Sergey Arlashin <
sergeyarl.maillist@gmail.com> wrote:
> 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.
>
If you looking at measuring read vs write activity on a Postgres database,
then a pgbadger report ( mentioned in this email thread earlier ) would
straight get you the %age of reads (SELECTS) vs %age of WRITES
(inserts/updates/deletes). Alternative tools would be "pgsi" or
"pg_query_analyzer" - all of these tools perform analysis on PostgreSQL
logfiles in pg_log directory and impose no over-head and consume very less
resources.
check_postgres.pl does not have a direct option of calculating read vs
write activity. Alternatively, you can write your own scripts (perl or
shell) and plug them into check_postgres.pl.
Through pg_stat* catalog tables, you can monitor read/write activity Table
or Index wise. Ex: I can find out which Table or Index is getting high
number of read or write requests.
Please let us know if you are what kind of monitoring you are looking at.
Regards,
Venkata Balaji N
Fujitsu Australia
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL 9.3: monitor read vs write activity
@ 2014-02-27 08:26 Viktor <spoon@planet.ee>
parent: Sergey Arlashin <sergeyarl.maillist@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Viktor @ 2014-02-27 08:26 UTC (permalink / raw)
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>; +Cc: pgsql-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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-02-27 08:26 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-02-14 07:09 PostgreSQL 9.3: monitor read vs write activity Sergey Arlashin <sergeyarl.maillist@gmail.com>
2014-02-14 08:16 ` jaime soler <jaime.soler@gmail.com>
2014-02-14 08:23 ` Raghavendra <raghavendra.rao@enterprisedb.com>
2014-02-26 19:54 ` Sergey Arlashin <sergeyarl.maillist@gmail.com>
2014-02-27 03:15 ` Venkata Balaji Nagothi <vbnpgc@gmail.com>
2014-02-27 08:26 ` Viktor <spoon@planet.ee>
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