解决postgresql数据库锁表问题

–pgsql锁表查询
select a.pid,b.oid,b.relname,c.state_change,query from pg_locks a
join pg_class b on a.relation = b.oid
join pg_stat_activity c on a.pid = c.pid
where a.mode like ‘%ExclusiveLock%’ ORDER BY c.state_change;

– pgsql释放锁
select pg_terminate_backend(a.pid) from pg_locks a
join pg_class b on a.relation = b.oid
join pg_stat_activity c on a.pid = c.pid
where a.mode like ‘%ExclusiveLock%’;

–pid释放锁
select pg_terminate_backend(‘144362’);