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';
20 select timestamp_ms as timestamp,
22 non_temporal(timestamp_ms) as end_time,
23 id_New_eNB_UE_X2AP_ID as eUE_ID,
24 id_SgNB_UE_X2AP_ID as gUE_ID,
27 from CONRELEASE.dc_release
31 DEFINE{query_name 'release_req_events';
32 max_lfta_disorder '1'; max_hfta_disorder '1';
35 merge p1.timestamp : p2.timestamp
36 from release_req_start p1, release_req_success p2
40 DEFINE{query_name 'release_req_success_time';
41 max_lfta_disorder '1'; max_hfta_disorder '1';
44 select gUE_ID, gnb_id, TB,
45 UINT(max(end_time)-max(start_time)) as success_time
46 from release_req_events
47 group by gUE_ID, gnb_id, timestamp / $window as TB
48 having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
51 DEFINE{query_name 'release_req_success_stats';
52 max_lfta_disorder '1'; max_hfta_disorder '1';
55 select gnb_id as GNB_ID,
56 ($window*(TB+1))/1000 as TS,
57 $window/1000.0 as measurementInterval,
58 MIN(success_time)/1000.0 as min_success_time,
59 MAX(success_time)/1000.0 as max_success_time,
60 AVG(success_time)/1000.0 as avg_success_time,
61 quantile_of(success_time, .05)/1000.0 as pctl_05_success_time,
62 quantile_of(success_time, .95)/1000.0 as pctl_95_success_time,
64 sum((success_time/1000.0)*(success_time/1000.0)) - sum(success_time/1000.0)*sum(success_time/1000.0)/count(*)
65 ) / count(*) as stddev_success_time
66 from release_req_success_time