postgres数据库锁表信息查询及解锁

1、查看锁表信息

select * from pg_locks l join pg_class t on l.relation = t.oid 
where t.relkind = 'r' and t.relname = 'table_name';

2、查看锁表的详细信息

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

3、查找所有活动的被锁的表

	select *
	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);