SELECT * FROM pg_locks;
'acquire lock' SELECT * FROM pg_thread_wait_status WHERE wat_status =
SOL>SELECT w.query as waiting_query,
w.pid as w_pid,
w.usename as w_user,
l.query as locking_query,
l.pid as l_pid,
l.usename as l_user,
t.schemaname || '.' || t.relname as tablename
from pg_stat_activity w
join pg_locks l1
on w.pid = l1.pid
and not l1.granted
join pg_locks l2
on l1.relation = l2.relation
and l2.granted
join pg_stat_activity l
on l2.pid = l.pid
join pg_stat_user_tables t
on l1.relation= t.relid
where w.waiting;
根据会话ID结束会话
SELECT PG_TERMINATE_BACKEND(139834762094352);
如果您发现该资源为电子书等存在侵权的资源或对该资源描述不正确等,可点击“私信”按钮向作者进行反馈;如作者无回复可进行平台仲裁,我们会在第一时间进行处理!
加入交流群
请使用微信扫一扫!