X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 89C6C474E42
	for <pgsql-sql@postgresql.org>; Tue,  6 May 2003 11:55:04 -0400 (EDT)
Received: from spirit.aldeiadigital.com.br
	(iplus-fac-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137])
	by postgresql.org (Postfix) with ESMTP id 1126B476495
	for <pgsql-sql@postgresql.org>; Tue,  6 May 2003 11:54:56 -0400 (EDT)
Received: from aldeiadigital.com.br (localhost.localdomain [127.0.0.1])
	by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id
	h46FtJs25243
	for <pgsql-sql@postgresql.org>; Tue, 6 May 2003 12:55:19 -0300
Received: from 200.170.145.209 (proxying for 192.168.1.1)
	(SquirrelMail authenticated user alepaes)
	by webmail.ad2.com.br with HTTP; Tue, 6 May 2003 12:55:19 -0300 (BRT)
Message-ID: <42378.200.170.145.209.1052236519.squirrel@webmail.ad2.com.br>
Date: Tue, 6 May 2003 12:55:19 -0300 (BRT)
Subject: pg_stat_activity IP address
From: "alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>
To: <pgsql-sql@postgresql.org>
X-Priority: 3
Importance: Normal
X-MSMail-Priority: Normal
X-Mailer: SquirrelMail (version 1.2.7)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
X-Virus-Scanned: by amavisd-milter (http://amavis.org/)
Content-Transfer-Encoding: quoted-printable
X-Spam-Status: No, hits=-5.7 required=5.0
	tests=BAYES_10,MISSING_MIMEOLE,MISSING_OUTLOOK_NAME version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/90
X-Sequence-Number: 13255

Hi,

I use pg_locks and pg_stat_activity to get the locked tables in
my database.

But I use the same user to all connections and pg_stat_activity
returns only the username.

I make a script that collect the IP address from ps and
concatenate with PID returned by pg_locks, but
is not usefull for a remote realtime statistic collect.

Thanks

Alexandre