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
13 DEFINE{query_name 'add_req_success';}
15 select timestamp_ms as timestamp,
17 non_temporal(timestamp_ms) as end_time,
18 id_MeNB_UE_X2AP_ID as eUE_ID,
21 from RECONCOMPLETE.reconfig_success
25 DEFINE{query_name 'addreq_events';}
27 merge p1.timestamp : p2.timestamp
28 from add_req_start p1, add_req_success p2
32 DEFINE{query_name 'addreq_success_time';
33 max_lfta_disorder '1'; max_hfta_disorder '1';
36 select eUE_ID, gnb_id, TB,
37 UINT(max(end_time)-max(start_time)) as success_time
39 group by eUE_ID, gnb_id, timestamp / $window as TB
40 having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
43 DEFINE{query_name 'addreq_success_stats';
44 max_lfta_disorder '1'; max_hfta_disorder '1';
45 comment 'statistics on the time to successfully make a DC connection';
48 select gnb_id as GNB_ID,
49 ($window*(TB+1))/1000 as TS,
50 $window/1000.0 as measurementInterval,
51 MIN(success_time)/1000.0 as min_success_time,
52 MAX(success_time)/1000.0 as max_success_time,
53 AVG(success_time)/1000.0 as avg_success_time,
54 quantile_of(success_time, .05)/1000.0 as pctl_05_success_time,
55 quantile_of(success_time, .95)/1000.0 as pctl_95_success_time,
57 sum((success_time/1000.0)*(success_time/1000.0)) - sum(success_time/1000.0)*sum(success_time/1000.0)/count(*)
58 ) / count(*) as stddev_success_time
59 from addreq_success_time