1 DEFINE{query_name 'dc_connect';
2 max_lfta_disorder '1'; max_hfta_disorder '1';
5 select timestamp_ms as timestamp,
6 UINT(id_MeNB_UE_X2AP_ID) as eUE_ID,
7 UINT(id_SgNB_UE_X2AP_ID) as gUE_ID,
9 from RECONCOMPLETE.reconfig_success
13 DEFINE{query_name 'dc_terminate';
14 max_lfta_disorder '1'; max_hfta_disorder '1';
17 select timestamp_ms as timestamp,
18 UINT(id_Old_eNB_UE_X2AP_ID) as eUE_ID,
19 id_SgNB_UE_X2AP_ID as gUE_ID,
21 from CONRELEASE.dc_release
25 DEFINE{query_name 'dc_events';}
27 merge p1.timestamp : p2.timestamp
28 from dc_connect p1, dc_terminate p2
32 DEFINE{ query_name 'mc_connected_ues';
33 max_lfta_disorder '1'; max_hfta_disorder '1';
37 ((TB+1)*$window-LAST(timestamp))/1000.0 as connected_time
39 GROUP BY timestamp / $window as TB, gUE_ID as UE_ID
40 HAVING LAST(event_type) = 1
41 CLOSING_WHEN LAST(event_type) = 0
44 DEFINE{ query_name 'mc_connected_cnt';
45 max_lfta_disorder '1'; max_hfta_disorder '1';
46 comment 'Number of dual connected users';
49 SELECT ($window*(TB+1))/1000 as TS,
50 $window/1000.0 as measurementInterval, // standard_name
51 COUNT(*) as count_connected_ue
56 DEFINE{ query_name 'mc_disconnected_ues';
57 max_lfta_disorder '1'; max_hfta_disorder '1';
60 SELECT TB_1000, UE_ID,
61 UINT((LAST(timestamp) - FIRST(timestamp))) as connected_time
63 GROUP BY timestamp / 1000 as TB_1000, gUE_ID as UE_ID
64 HAVING LAST(event_type) = 0
65 CLOSING_WHEN LAST(event_type) = 0
69 DEFINE{ query_name 'mc_connection_stats';
70 max_lfta_disorder '1'; max_hfta_disorder '1';
71 comment 'statistics about the length of dual connected sessions';
74 SELECT ($window*(TB+1))/1000 as TS,
75 $window/1000.0 as measurementInterval, // standard_name
76 MIN(connected_time)/1000.0 as min_connected_time,
77 MAX(connected_time)/1000.0 as max_connected_time,
78 AVG(connected_time)/1000.0 as avg_connected_time,
79 quantile_of(connected_time, .05)/1000.0 as pctl_05_connected_time,
80 quantile_of(connected_time, .95)/1000.0 as pctl_95_connected_time,
82 sum((connected_time/1000.0)*(connected_time/1000.0)) - sum(connected_time/1000.0)*sum(connected_time/1000.0)/count(*)
83 ) / count(*) as stddev_connected_time
84 FROM mc_disconnected_ues
85 GROUP BY (TB_1000 * 1000) / $window as TB
89 DEFINE{ query_name 'mc_connects_cnt';
90 max_lfta_disorder '1'; max_hfta_disorder '1';
91 comment 'number of DC connection requests';
94 SELECT ($window*(TB+1))/1000 as TS,
95 $window/1000.0 as measurementInterval, // standard_name
96 COUNT(*) as count_ue_connects
99 GROUP BY timestamp / $window as TB
102 DEFINE{ query_name 'mc_disconnects_cnt';
103 max_lfta_disorder '1'; max_hfta_disorder '1';
104 comment 'number of DC connection releases';
106 PARAM{ window uint; }
107 SELECT ($window*(TB+1))/1000 as TS,
108 $window/1000.0 as measurementInterval, // standard_name
109 COUNT(*) as count_ue_disconnects
112 GROUP BY timestamp / $window as TB
115 DEFINE{ query_name 'mc_unique_ues';
116 max_lfta_disorder '1'; max_hfta_disorder '1';
118 PARAM{ window uint; }
121 GROUP BY timestamp / $window as TB, gUE_ID as UE_ID
124 DEFINE{ query_name 'mc_unique_ue_cnt';
125 max_lfta_disorder '1'; max_hfta_disorder '1';
126 comment 'Number of distinct UEs making a DC request or release';
128 PARAM{ window uint; }
129 SELECT ($window*(TB+1))/1000 as TS,
130 $window/1000.0 as measurementInterval, // standard_name
131 COUNT(*) as count_unique_ue