[PGSQL] 락조회 / 락KILL

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});

Lock kill