PostgresSQL 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 테이블 Kill

SELECT pg_cancel_backend([pid]);

SELECT pg_terminate_backend([pid]) FROM pg_stat_activity;