3 // join interval should be 10 seconds
4 // Compromise between ensuring that most add_req_ack-recon_complete pairs
5 // are caught while avoiding duplicates due to short sessions
6 // NB: $window should be a multiple of 10.
7 DEFINE{query_name 'erab_stats_join';
8 max_lfta_disorder '1'; max_hfta_disorder '1';
11 select e.timestamp_ms/10000 as TB10, e.id_SgNB_UE_X2AP_ID, e.e_RAB_ID, e.qCI
13 INNER_JOIN from SGNB_ADDITION_REQ_ACK.eRABs_acked_for_admit_for_ue e,
14 RECONCOMPLETE.reconfig_success r
16 r.id_SgNB_UE_X2AP_ID = e.id_SgNB_UE_X2AP_ID
17 and r.timestamp_ms/10000 = e.timestamp_ms/10000
21 DEFINE{query_name 'erab_stats';
22 max_lfta_disorder '1'; max_hfta_disorder '1';
23 comment 'number of admitted bearers and the distribution of their qCI';
26 Select (TB*$window)/1000 as TS, gnb_id as GNB_ID,
27 $window/1000.0 as measurementInterval,
28 count(*) as total_erabs,
29 sum( EQ(UINT(qCI),1) ) as qCI_1,
30 sum( EQ(UINT(qCI),2) ) as qCI_2,
31 sum( EQ(UINT(qCI),3) ) as qCI_3,
32 sum( EQ(UINT(qCI),4) ) as qCI_4,
33 sum( EQ(UINT(qCI),5) ) as qCI_5,
34 sum( EQ(UINT(qCI),6) ) as qCI_6,
35 sum( EQ(UINT(qCI),7) ) as qCI_7,
36 sum( EQ(UINT(qCI),8) ) as qCI_8,
37 sum( EQ(UINT(qCI),9) ) as qCI_9,
38 sum( LEQ(UINT(qCI),0)| GEQ(UINT(qCI),10) ) as qCI_other
40 group by (10000*TB10)/$window as TB, gnb_id