vertica mon query + 몇개더

Vertica 에서 사용하는 모니터링용 query 몇개 기록해 두자

1. 데이터 적재하는 상황보기 load stream
vsql << +
select table_name, accepted_row_count, rejected_row_count, parse_complete_percent, sort_complete_percent from load_streams
where is_executing ;
+

2. session 상황보기
vsql << +
select node_name, user_name, session_id, statement_id, transaction_id, start_time, current_statement
from sessions
where current_statement != '' and session_id != current_session()
order by 6
;
+

3. resource pool 상태보기
vsql << +
select rps.pool_name, rps.node_name, cast((memory_size_actual_kb)/1024 as dec(10,2)) as 'act(M)', cast((memory_inuse_kb)/1024 as dec(10,2)) as 'use(M)', cast((general_memory_borrowed_kb)/1024 as dec(10,2)) as 'borr(M)', max_concurrency, planned_concurrency, running_query_count, cpu_affinity_set, max(rq.position_in_queue)
from resource_pool_status rps
left outer join resource_queue rq on rps.pool_name=rq.pool_name
and rps.node_name=rq.node_name
where rps.pool_name not in ('dbd','recovery','refresh','sysdata','sysquery','wosdata','tm','jvm')
group by 1,2,3,4,5,6,7,8,9
order by 1,2