查看被锁的表
select a.locktype,a.database,a.pid,a.mode,a.relation,b.relname
from pg_locks a
join pg_class b on a.relation = b.oid
记下他的pid,然后
select pg_terminate_backend(‘pid’)
select pg_cancel_backend(pid);
杀掉进程
over
查询所有的进程
SELECT * FROM pg_stat_activity