解决postgresql数据库锁表问题–pgsql锁表查询select a.pid,b.oid,b.relname,c.state_change,query from pg_locks ajoin pg_class b on a.relation = b.oidjoin pg_stat_activity c on a.pid = c.pidwhere a.mode like ‘%Exclusive