–可以用下面语句处理锁表
–查询锁表任务
select
*
from
pg_stat_activity
where
datname = ‘MES2_PRD’
AND wait_event_type = ‘Lock’
order by query_start
–如果找不到锁表的语句，看执行时间最早的几个，一般是update语句
select
*
from
pg_stat_activity
where
datname = ‘MES2_PRD’
order by query_start
–终止进程pid
select pg_terminate_backend(查出来的pid);
–批量终止
select
‘select pg_terminate_backend(‘ ||pid||’)’
from
pg_stat_activity
where
datname = ‘MES2_PRD’
order by query_start