Query runtime distribution

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Displays a relative query duration over time.

The query that is used:

set timezone to gmt; SELECT DATE_PART('epoch',now()) as now, DATE_PART('epoch', min_start) as min_start,
DATE_PART('epoch', max_start) as max_start, num_2sec, num_2sec_60sec, num_60sec_5min, num_5min_10min,
num_10min_30min, num_30min_1hour, num_1hour_5hours, num_5hours FROM ( SELECT nvl(sum(case when (exectime <
'2 sec'::interval) then qnum else NULL end),0) as num_2sec, nvl(sum(case when (exectime >= '2 sec'::interval
and exectime < '60 sec'::interval) then qnum else NULL end),0) as num_2sec_60sec, nvl(sum(case when (exectime
>= '60 sec'::interval and exectime < '5 min'::interval) then qnum else NULL end),0) as num_60sec_5min,
nvl(sum(case when (exectime >= '5 min'::interval and exectime < '10 min'::interval) then qnum else NULL end),0)
as num_5min_10min, nvl(sum(case when (exectime >= '10 min'::interval and exectime < '30 min'::interval) then
qnum else NULL end),0) as num_10min_30min, nvl(sum(case when (exectime >= '30 min'::interval and exectime < '1
hour'::interval) then qnum else NULL end),0) as num_30min_1hour, nvl(sum(case when (exectime >=
'1 hour'::interval and exectime < '5 hours'::interval) then qnum else NULL end),0) as num_1hour_5hours,
nvl(sum(case when (exectime >= '5 hours'::interval) then qnum else NULL end),0) as num_5hours from (select
nvl(age(qh_tend,qh_tstart),'0 sec'::interval) as exectime, count(exectime) as qnum from _v_qryhist group by
exectime) series ) aggr CROSS JOIN (select min(qh_tstart) min_start, max(qh_tstart) max_start from _v_qryhist)
min_max