[postgreSQL] DB LOCK 확인

--Lock 테이블 확인
 

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

 -- lock 해제

select pg_cancel_backend({pid});