[PostgreSQL] 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);