Redshift 쿼리 자원 할당 모니터링 하는 방법

현재 실행중인 쿼리 text, pid 확인하기

https://docs.aws.amazon.com/ko_kr/redshift/latest/dg/r_STV_RECENTS.html

SELECT *
FROM stv_recents
WHERE status = 'Running'
ORDER BY starttime DESC;

현재 실행 중인 쿼리의 query id, pid 확인하기

https://docs.aws.amazon.com/ko_kr/redshift/latest/dg/r_SVV_QUERY_INFLIGHT.html

SELECT *
FROM svv_query_inflight;

특정 쿼리의 자원 할당량 확인하기

SELECT *
FROM svl_query_summary
WHERE query = '1612331392';

SELECT SUM(workmem)                             AS work_mem_bytes
     , SUM(workmem)::FLOAT / 1024 / 1024 / 1024 AS work_mem_gb
     , SUM(workmem)::FLOAT / 1000 / 1000 / 1000 AS work_mem_gb
FROM svl_query_summary
WHERE query = '1612331392';