pg 锁住/解锁

lock.sql

select pid, query
from pg_stat_activity
where datname = 'table'
  and wait_event_type = 'Lock';

select 'select pg_cancel_backend( ''' || pid || ''');' pid
from pg_stat_activity
where datname = 'table'
  and wait_event_type = 'Lock';