Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 95B6D1337BA5
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  2 Feb 2011 12:14:44 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 65887-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed,  2 Feb 2011 16:14:37 +0000 (UTC)
X-Greylist: delayed 00:09:58.475955 by SQLgrey-1.7.6
Received: from mail.affinitas.de (static.78.108.40.188.clients.your-server.de
	[188.40.108.78])
	by mail.postgresql.org (Postfix) with ESMTP id C6AAF1337BA0
	for <pgsql-performance@postgresql.org>;
	Wed,  2 Feb 2011 12:14:36 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.affinitas.de (Postfix) with ESMTP id 7E37F68C010
	for <pgsql-performance@postgresql.org>;
	Wed,  2 Feb 2011 17:06:26 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at mail.affinitas.de
Received: from mail.affinitas.de ([127.0.0.1])
	by localhost (mail.affinitas.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id HHo3FiYSwouF for <pgsql-performance@postgresql.org>;
	Wed,  2 Feb 2011 17:06:25 +0100 (CET)
Received: from affinitas180.localnet (unknown [91.102.12.2])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.affinitas.de (Postfix) with ESMTPSA
	for <pgsql-performance@postgresql.org>;
	Wed,  2 Feb 2011 17:06:25 +0100 (CET)
From: Jens Wilke <jens.wilke@affinitas.de>
Organization: Affinitas GmbH
To: pgsql-performance@postgresql.org
Subject: monitoring querys Re: About pg_stat_activity
Date: Wed, 2 Feb 2011 17:03:42 +0100
User-Agent: KMail/1.13.5 (Linux/2.6.32-5-amd64; KDE/4.4.5; x86_64; ; )
References: <AANLkTi=XvdtT0mDQC1CmU=GwzhhbCKuhVvxRMzTN2_Ki@mail.gmail.com>
In-Reply-To: <AANLkTi=XvdtT0mDQC1CmU=GwzhhbCKuhVvxRMzTN2_Ki@mail.gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Message-Id: <201102021703.42658.jens.wilke@affinitas.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201102/22
X-Sequence-Number: 42160

On Wednesday 02 February 2011 16:21:47 Cesar Arrieta wrote:

Hi,

> If you could help looking about this, or if you know about an app that
> already do this, please let me know.

have a look for http://pgfouine.projects.postgresql.org/ 
and http://pgfoundry.org/projects/pgstatspack/

HTH, 
Jens