postgresql lock 테이블 조회 및 kill

lock 테이블 조회

select  
	b.relname,
	a.locktype,
	page,
	virtualtransaction,
	pid,
	mode,
	granted
from pg_locks a, pg_stat_all_tables b
where a.relation = b.relid
order by relation asc;

process kill

select pg_cancel_backend(pid);