2 // join interval should be 10 seconds
3 // Compromise between ensuring that most add_req_ack-recon_complete pairs
4 // are caught while avoiding duplicates due to short sessions
5 // NB: $window should be a multiple of 10.
6 DEFINE{query_name 'erab_stats_join';}
8 select e.timestamp_ms/10000 as TB10, e.id_SgNB_UE_X2AP_ID, e.e_RAB_ID, e.qCI
9 INNER_JOIN from SGNB_ADDITION_REQ_ACK.eRABs_acked_for_admit_for_ue e,
10 RECONCOMPLETE.reconfig_success r
11 where r.schemaId = 101 and e.schemaId = 502
12 and r.id_SgNB_UE_X2AP_ID = e.id_SgNB_UE_X2AP_ID
13 and r.timestamp_ms/10000 = e.timestamp_ms/10000
16 DEFINE{query_name 'erab_stats';}
18 Select (TB*$window)/1000 as TS,
19 $window/1000.0 as measurementInterval,
20 count(*) as total_erabs,
21 sum(EQ(UINT(qCI),1)) as qCI_1,
22 sum(EQ(UINT(qCI),2)) as qCI_2,
23 sum(EQ(UINT(qCI),3)) as qCI_3,
24 sum(EQ(UINT(qCI),4)) as qCI_4,
25 sum(EQ(UINT(qCI),5)) as qCI_5,
26 sum(EQ(UINT(qCI),6)) as qCI_6,
27 sum(EQ(UINT(qCI),7)) as qCI_7,
28 sum(EQ(UINT(qCI),8)) as qCI_8,
29 sum(EQ(UINT(qCI),9)) as qCI_9,
30 sum(LEQ(UINT(qCI),0))+sum(GEQ(UINT(qCI),10)) as qCI_other
32 group by (10000*TB10)/$window as TB