pgsql锁表解决

差点给业务干崩

1、查询出锁表进程

select * from pg_stat_activity where state = 'active';

2、如果知道表名，也可以使用表名查询

select * from pg_locks where relation=(select oid from pg_class where relname='scr_doc_currency');

3、结束锁表进程

select pg_terminate_backend('6775')