PostgreSQL 테이블 Lock 확인/삭제

--lack 테이블 확인

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;

--lack 삭제

select pg_cancel_backend(pid);