select * from pg_catalog.pg_stat_activity where usename =’gis_bd_app’ and wait_event_type = ‘Lock’;
select * from pg_locks where relation=
(select oid from pg_class where relname=’可能锁表了的表’);
–取消后台操作,回滚未提交事物
select pg_cancel_backend(上面查到的pid)
–中断session,回滚未提交事物
select pg_terminate_backend(上面查到的pid)
Original: https://www.cnblogs.com/wxdnq/p/16456119.html
Author: 微笑带你去
Title: pg 锁表
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/576320/
转载文章受原作者版权保护。转载请注明原作者出处!