From: Steve Crawford <scrawford@pinpointresearch.com>
To: Kellyton Campos Feitosa - GYN <Kellyton.Feitosa@gyn.politec.com.br>
Cc: hackers@postgresql.org, "pgsql-admin@postgresql.org Admin" <pgsql-admin@postgresql.org>
Subject: Re: [HACKERS] Monitoring postgres
Date: Mon, 06 Oct 2008 08:47:29 -0700
Message-ID: <48EA3311.1060204@pinpointresearch.com> (raw)
In-Reply-To: <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br>
References: <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br>
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.htmlhttp://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
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: scrawford@pinpointresearch.com, Kellyton.Feitosa@gyn.politec.com.br
Subject: Re: [HACKERS] Monitoring postgres
In-Reply-To: <48EA3311.1060204@pinpointresearch.com>
* 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