-- 컬럼 타입 확인
SELECT column_name, data_type
FROM   information_schema.columns
WHERE  table_name = 'rank_product'
ORDER  BY ordinal_position;

-- 실행중 쿼리 확인
SELECT * FROM pg_stat_activity ORDER BY query_start ASC;

-- 쿼리 취소
SELECT pg_cancel_backend(5045);

-- 쿼리 종료
SELECT pg_terminate_backend(8486)

-- 3분 이상 지난 쿼리 확인
select pid, query_start, query from pg_stat_activity where pid in (select distinct pid from pg_locks) and  current_timestamp - query_start > interval '180' second;