[PostgreSQL] 테이블 Lock 확인하기

-- pgsql 에서 테이블 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 수동으로 걸어주기

BEGIN WORK;

LOCK TABLE tblTest IN ACCESS EXCLUSIVE MODE;

--LOCK TABLE tblTest IN EXCLUSIVE MODE;

--LOCK TABLE tblTest IN SHARE ROW EXCLUSIVE MODE;

--LOCK TABLE tblTest IN SHARE MODE;

--LOCK TABLE tblTest IN SHARE UPDATE EXCLUSIVE MODE;

--LOCK TABLE tblTest IN ROW EXCLUSIVE MODE;

--LOCK TABLE tblTest IN ROW SHARE MODE;

--LOCK TABLE tblTest IN ACCESS SHARE MODE;

COMMIT WORK;