pg_stat_activity IP address - Mailing list pgsql-sql

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