나의 갱년기 일기

https://x2wizard.github.io/vertica_use/Vertica_use_2003/

https://www.vertica.com/docs/9.2.x/HTML/Content/Home.htm

--lock 상태 확인 SELECT * FROM locks; --리소스 사용량 SELECT * FROM resource_usage; --cpu 사용량 SELECT * FROM cpu_usage where start_time between '2023-07-10 15:50:00' and '2023-07-10 16:28' ORDER BY start_time desc; --세션 수 SELECT USER_name,count(1) FROM sessions GROUP BY 1; --수행중인 쿼리 SELECT * FROM query_requests WHERE is_executing ='t' ORDER BY start_timestamp DESC; SELECT * FROM query_requests ORDER BY sta..

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..

1. 테이블 스페이스별 현재파일용량 / 사용량 / 미사용량 확인 2. 테이블 스페이스 최적화 가능 용량 확인 3. 테이블 스페이스 최소용량으로 RESIZE 하기 ------------------------------------------------------------------ -- 테이블스페이스별 현재파일용량/사용량/미사용량 확인 SELECT DECODE(GROUPING(TABLESPACE_NAME), 1, 'TOTAL', TABLESPACE_NAME) AS TABLESPACE_NAME , SUM(TOTAL_MB) AS TOTAL_GB , SUM(USED_MD) AS USED_GB , SUM(FREE_MB) AS FREE_GB , TO_CHAR(ROUND(SUM(USED_MD) / SUM(TOTAL_..

SELECT t.tn AS tn ,TO_CHAR(TRUNC(((f.fs/t.ts)*100),2))||'% ' AS freep ,TO_CHAR(TRUNC((((t.ts-f.fs)/t.ts)*100),2))||'%' AS usedp ,t.ts AS bts ,(t.ts-f.fs) AS used ,f.fs AS free FROM (SELECT tablespace_name AS tn ,SUM(bytes/1024/1024) AS ts FROM dba_data_files GROUP BY tablespace_name) t ,(SELECT tablespace_name AS tn ,SUM(bytes/1024/1024) AS fs FROM dba_free_space GROUP BY tablespace_name) f WHER..