1 DEFINE{query_name 'release_req_start';
2 max_lfta_disorder '1'; max_hfta_disorder '1';
5 select timestamp_ms as timestamp,
6 non_temporal(timestamp_ms) as start_time,
8 id_MeNB_UE_X2AP_ID as eUE_ID,
9 id_SgNB_UE_X2AP_ID as gUE_ID,
12 from RELREQ.release_req
16 DEFINE{query_name 'release_req_success';
17 max_lfta_disorder '1'; max_hfta_disorder '1';
18 comment 'statistics on the time to delease a DC connection';
21 select timestamp_ms as timestamp,
23 non_temporal(timestamp_ms) as end_time,
24 id_New_eNB_UE_X2AP_ID as eUE_ID,
25 id_SgNB_UE_X2AP_ID as gUE_ID,
28 from CONRELEASE.dc_release
32 DEFINE{query_name 'release_req_events';
33 max_lfta_disorder '1'; max_hfta_disorder '1';
36 merge p1.timestamp : p2.timestamp
37 from release_req_start p1, release_req_success p2
41 DEFINE{query_name 'release_req_success_time';
42 max_lfta_disorder '1'; max_hfta_disorder '1';
45 select gUE_ID, gnb_id, TB,
46 UINT(max(end_time)-max(start_time)) as success_time
47 from release_req_events
48 group by gUE_ID, gnb_id, timestamp / $window as TB
49 having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
52 DEFINE{query_name 'release_req_success_stats';
53 max_lfta_disorder '1'; max_hfta_disorder '1';
54 comment 'statistics on the time to delease a DC connection';
57 select gnb_id as GNB_ID,
58 ($window*(TB+1))/1000 as TS,
59 $window/1000.0 as measurementInterval,
60 MIN(success_time)/1000.0 as min_success_time,
61 MAX(success_time)/1000.0 as max_success_time,
62 AVG(success_time)/1000.0 as avg_success_time,
63 quantile_of(success_time, .05)/1000.0 as pctl_05_success_time,
64 quantile_of(success_time, .95)/1000.0 as pctl_95_success_time,
66 sum((success_time/1000.0)*(success_time/1000.0)) - sum(success_time/1000.0)*sum(success_time/1000.0)/count(*)
67 ) / count(*) as stddev_success_time
68 from release_req_success_time