제니퍼 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;