[postgresql] 락 확인

조회

select * from pg_locks;

select * from pg_stat_activity;

select * from pg_stat_activity where state = 'active';

락 걸린 프로그램 취소

SELECT pg_cancel_backend(9228);