postgresql查询锁表pid，SQL、开始时间、执行SQL的ip地址

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';