基于postgresql数据库锁表问题的解决

select oid from pg_class where relname='可能锁表了的表'
select pid from pg_locks where relation='上面查出的oid'

select pg_cancel_backend(上面查到的pid)

SELECT T
 .PID,
 T.STATE,
 T.QUERY,
 T.WAIT_EVENT_TYPE,
 T.WAIT_EVENT,
 T.QUERY_START 
FROM
 PG_STAT_ACTIVITY T
WHERE
 T.DATNAME = '数据库用户名';

SELECT T
 .PID,
 T.STATE,
 T.QUERY,
 T.WAIT_EVENT_TYPE,
 T.WAIT_EVENT,
 T.QUERY_START 
FROM
 PG_STAT_ACTIVITY T 
WHERE
 T.DATNAME = '数据库用户名' 
 AND T.WAIT_EVENT_TYPE = 'Lock';

select PG_CANCEL_BACKEND('6984');

select pg_terminate_backend ('21967')