[VERTICA] cpu 사용률이 높은 SQL 확인

SELECT *
  FROM QUERY_CONSUMPTION
 WHERE END_TIME >='2023-09-19 04:30:00'
 ORDER BY CPU_CYCLES_US DESC
 ;
 
 SELECT *
   FROM QUERY_REQUESTS
  WHERE TRANSACTION_ID = 45035996354369711
    AND STATEMENT_ID = 4
  ;

 

[ 실시간 모니터링 ]

SELECT user_name, session_id, transaction_id, statement_id, sum(counter_value)//1024^3 as cpu_usage

FROM vs_execution_engine_profiles 

where counter_name ilike 'execution time (us)'

group by 1,2,3,4

order by 5 desc

limit 10