查询因为锁表而等待的语句
----因为锁表而等待的语句
select
*
from
pg_stat_activity
where
waiting_reason = 'lock'
--and datname='apldb'
;
锁表查询
--锁表查询
select
distinct b.pid
from
pg_class a,
pg_locks b
where
a.oid = b.relation
--and a.relname='table_name'
;
锁表处理
--锁表处理
select pg_cancel_backend(32445); --pid
杀会话
select pg_terminate_backend(14828); --pid
--杀掉tjbb39下所有不活跃的无效的会话
select pg_terminate_backend(pid) from pg_stat_activity WHERE datname='apldb' and usename = 'tjbb39' and state = 'idle';