제니퍼 APM 주요 SQL

select a.log_hh, a.visit_hour, b.visit_hour, c.visit_hour
from
(select agent_id, log_hh, avg(visit_hour) as visit_hour
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP1')
group by agent_id, log_hh ) a,
(select agent_id, log_hh, avg(visit_hour) as visit_hour
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP2')
group by agent_id, log_hh ) b,
(select agent_id, log_hh, avg(visit_hour) as visit_hour
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP3')
group by agent_id, log_hh ) c
where a.log_hh = b.log_hh
and a.log_hh = c.log_hh;

select a.log_hh, a.hit, a.arrival_rate, a.active_service
, b.hit, b.arrival_rate, b.active_service
, c.hit, c.arrival_rate, c.active_service
from
(select agent_id, log_hh, avg(visit_hour) as visit_hour, sum(hit) as hit
, avg(arrival_rate) as arrival_rate
, avg(active_service) as active_service
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP1')
group by agent_id, log_hh ) a,
(select agent_id, log_hh, avg(visit_hour) as visit_hour, sum(hit) as hit
, avg(arrival_rate) as arrival_rate
, avg(active_service) as active_service
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP2')
group by agent_id, log_hh ) b,
(select agent_id, log_hh, avg(visit_hour) as visit_hour, sum(hit) as hit
, avg(arrival_rate) as arrival_rate
, avg(active_service) as active_service
from s_perf_x
where log_dt like '201311%'
and agent_id in ('AP3')
group by agent_id, log_hh ) c
where a.log_hh = b.log_hh
and a.log_hh = c.log_hh;