Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Monitoring postgres

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Kellyton Campos Feitosa - GYN <Kellyton(dot)Feitosa(at)gyn(dot)politec(dot)com(dot)br>
Cc: hackers(at)postgresql(dot)org, "pgsql-admin(at)postgresql(dot)org Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [HACKERS] Monitoring postgres
Date: 2008-10-06 15:47:29
Message-ID: 48EA3311.1060204@pinpointresearch.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Kellyton Campos Feitosa - GYN wrote:
>
> Dears,
>
> I need monitor a postgres database, but I don’t know which tool to use.
>
> The tool need perform the below actions
>
>    1. show transactions pendents
>    2. show the statistics per session actives
>    3. show the statistics per database
>    4. show metrics per session and database
>    5. show rows locks
>    6. show slow activities statements (SELECT, INSERT, UPDATE, DELETE)
>    7. to allow set a trace to a specific session, similar the tool
>       dbms_system.SET_SQL_TRACE_IN_SESSION include in Oracle Database
>
>
This is better asked in the administration (or general) mailing list. I 
don't know of a single magic-bullet tool that does everything you list 
but you might try with the PostgreSQL docs starting with the monitoring 
and logging sections.
http://www.postgresql.org/docs/8.3/interactive/monitoring.html
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html

Then Google "postgresql monitoring tool" and see what's available 
including commercial products from EnterpriseDB:
http://www.enterprisedb.com/products/postgres_plus_as.do (dig into the 
docs and see what their monitoring stuff does)
and monitoring tools such as Hyperic that have PostgreSQL plugins:
http://www.hyperic.com/products/managed/postgresql-management.htm

Cheers,
Steve

In response to

pgsql-hackers by date

Next:From: Decibel!Date: 2008-10-06 15:57:28
Subject: Re: Bad error message
Previous:From: Decibel!Date: 2008-10-06 15:44:36
Subject: Re: FSM rewrite committed, loose ends

pgsql-admin by date

Next:From: Decibel!Date: 2008-10-06 17:00:36
Subject: Re: Still working on it...
Previous:From: Scott MarloweDate: 2008-10-06 15:08:32
Subject: Re: Postgres database as a client/server architecture

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group