postgresql查看锁表的进程

select pg_class.relname AS 表名,pg_database.datname AS 数据库,pg_locks.pid as pg进程,client_addr || ‘:’ || client_port as 客户端地址,mode,
pg_stat_activity.application_name as 程序名称 from pg_locks,pg_class,pg_database,pg_stat_activity
where pg_locks.relation = pg_class.oid and pg_class.reltype != 0 and pg_locks.database = pg_database.oid and pg_locks.pid = pg_stat_activity.pid
and pg_class.relname = ‘tablename’;