Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 4B1FF37C874;
	Mon,  6 Oct 2008 12:47:39 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 18690-09; Mon,  6 Oct 2008 12:47:31 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from polaris.pinpointresearch.com
	(66-7-238-130.static-ip.telepacific.net [66.7.238.130])
	by postgresql.org (Postfix) with ESMTP id BF02237BAE0;
	Mon,  6 Oct 2008 12:47:31 -0300 (ADT)
Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com
	[192.168.1.179])
	by polaris.pinpointresearch.com (Postfix) with ESMTP id 0B597E00EC84;
	Mon,  6 Oct 2008 08:47:30 -0700 (PDT)
Message-ID: <48EA3311.1060204@pinpointresearch.com>
Date: Mon, 06 Oct 2008 08:47:29 -0700
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
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
References: 
 <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br>
In-Reply-To: 
 <90A612EE1B6E4C4085ECC7DDED0A004B01EFF61D@gynserv002.gyn.politec.com.br>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200810/30
X-Sequence-Number: 30486

Kellyton Campos Feitosa - GYN wrote:
>
> Dears,
>
> I need monitor a postgres database, but I don=92t know which tool to us=
e.
>
> 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=20
don't know of a single magic-bullet tool that does everything you list=20
but you might try with the PostgreSQL docs starting with the monitoring=20
and logging sections.
http://www.postgresql.org/docs/8.3/interactive/monitoring.html
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.htm=
l

Then Google "postgresql monitoring tool" and see what's available=20
including commercial products from EnterpriseDB:
http://www.enterprisedb.com/products/postgres_plus_as.do (dig into the=20
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