Postgresql

-- 컬럼 타입 확인
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;