1 DEFINE{query_name 'add_req_start';}
3 select timestamp_ms as timestamp,
4 non_temporal(timestamp_ms) as start_time,
6 id_MeNB_UE_X2AP_ID as eUE_ID,
9 from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
12 DEFINE{query_name 'add_req_success';}
14 select timestamp_ms as timestamp,
16 non_temporal(timestamp_ms) as end_time,
17 id_MeNB_UE_X2AP_ID as eUE_ID,
20 from RECONCOMPLETE.reconfig_success
23 DEFINE{query_name 'addreq_events';}
25 merge p1.timestamp : p2.timestamp
26 from add_req_start p1, add_req_success p2
30 DEFINE{query_name 'addreq_success_time';
31 max_lfta_disorder '1'; max_hfta_disorder '1';
34 select eUE_ID, gnb_id, TB,
35 UINT(max(end_time)-max(start_time)) as success_time
37 group by eUE_ID, gnb_id, timestamp / $window as TB
38 having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
41 DEFINE{query_name 'addreq_success_stats';
42 max_lfta_disorder '1'; max_hfta_disorder '1';
43 comment 'statistics on the time to successfully make a DC connection';
46 select gnb_id as GNB_ID,
47 ($window*(TB+1))/1000 as TS,
48 $window/1000.0 as measurementInterval,
49 MIN(success_time)/1000.0 as min_success_time,
50 MAX(success_time)/1000.0 as max_success_time,
51 AVG(success_time)/1000.0 as avg_success_time,
52 quantile_of(success_time, .05)/1000.0 as pctl_05_success_time,
53 quantile_of(success_time, .95)/1000.0 as pctl_95_success_time,
55 sum((success_time/1000.0)*(success_time/1000.0)) - sum(success_time/1000.0)*sum(success_time/1000.0)/count(*)
56 ) / count(*) as stddev_success_time
57 from addreq_success_time