SELECT distinct
pg_stat_get_backend_pid (S.backendid) AS pid,
pg_stat_get_backend_activity_start (S.backendid) AS start_time,
pg_stat_get_backend_activity (S.backendid) AS query_sql,
m.client_addr as ip_addr
FROM(SELECT pg_stat_get_backend_idset () AS backendid) s , pg_locks t,pg_class p,pg_stat_activity m
where pg_stat_get_backend_pid (S.backendid)=t.pid and t.relation=p.oid and m.pid=t.pid
and p.relname='table_name';