[postgres@apm ~]$ ps -ef|grep 'postgres:'|grep -v grep|awk '{print $2}'|xargs kill -9

鎖：

?1 查找鎖表的pid

select pid?from pg_locks l?join pg_class t?on l.relation = t.oid?where t.relkind =?'r'?and t.relname =?'lockedtable';

2 查找鎖表的語句

select pid, state, usename,?query, query_start?from pg_stat_activity?where pid?in (?select pid?from pg_locks l?join pg_class t?on l.relation = t.oid?and t.relkind =?'r'?where t.relname = ?'lockedtable');

3 查找所有活動的被鎖的表

select pid, state, usename, query, query_start 
from pg_stat_activity 
where pid in (select pid from pg_locks l join pg_class t on l.relation = t.oid and t.relkind = 'r' );

4 解鎖

SELECT pg_cancel_backend(pid);

?5 批量(未排除自己)

select pg_cancel_backend(pid)
from pg_stat_activity 
where pid in (select pid from pg_locks l join pg_class t on l.relation = t.oid and t.relkind = 'r' );

參考:

1?https://jaketrent.com/post/find-kill-locks-postgres/

2?https://www.postgresonline.com/journal/archives/134-Terminating-Annoying-Back-Ends.html