postgresql 解锁表语句

解锁表语句：

select 

a.locktype,

a.database,

a.pid,

a.mode,

a.relation,

a.relname

from

pg_locks a join pg_class b on a.relation = b.oid

where 

b.relname = 'sws_fs_target_kpi_allot_month';

select pg_cancel_backend(17962);