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