postgres query

쓸만한 쿼리들 정리

테이블 전체 조회

SELECT * 
FROM pg_catalog.pg_tables 
WHERE schemaname = 'public';

현재 프로세스 조회

SELECT * from pg_stat_activity;

락 걸린 테이블 확인

 -- locked table
 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;

-- kill process  
SELECT pg_cancel_backend([pid]);
SELECT pg_terminate_backend([pid]) FROM pg_stat_activity;