mc-core/mc/queries/reconfig_status.gsql

   1 DEFINE{query_name 'reconfig_status_start';}
   2 PARAM{ window uint; }
   3 select timestamp_ms as timestamp,
   4         non_temporal(timestamp_ms) as start_time,
   5         0ULL as end_time,
   6         id_MeNB_UE_X2AP_ID as eUE_ID,
   7         gnb_id,
   8         0 as event_type
   9 from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
  10 // where schemaId=401
  11 ;
  12
  13 DEFINE{query_name 'reconfig_status_success';
  14 }
  15 PARAM{ window uint; }
  16 select timestamp_ms as timestamp,
  17         0ULL as start_time,
  18         non_temporal(timestamp_ms) as end_time,
  19         id_MeNB_UE_X2AP_ID as eUE_ID,
  20         gnb_id,
  21         1 as event_type
  22 from RECONCOMPLETE.reconfig_success
  23 // where schemaId=101
  24 ;
  25
  26 DEFINE{query_name 'reconfig_status_events';}
  27 PARAM{ window uint; }
  28 merge p1.timestamp : p2.timestamp
  29 from reconfig_status_start p1, reconfig_status_success p2
  30 ;
  31
  32
  33 DEFINE{query_name 'reconfig_status_merge';
  34         max_lfta_disorder '1'; max_hfta_disorder '1';
  35 }
  36 PARAM{ window uint; }
  37 select eUE_ID, gnb_id, TB,
  38         max(start_time) as max_start_time,
  39         max(end_time) as max_end_time
  40 from reconfig_status_events
  41 group by eUE_ID, gnb_id, timestamp / $window as TB
  42 ;
  43
  44 DEFINE{query_name 'reconfig_status_success_rate';
  45         max_lfta_disorder '1'; max_hfta_disorder '1';
  46         comment 'fraction of DC connect requests which are successful';
  47 }
  48 PARAM{ window uint; }
  49 select gnb_id as GNB_ID,
  50         ($window*(TB+1))/1000 as TS,
  51              $window/1000.0 as measurementInterval,
  52         count(*) as total_reconfiguration_requests,
  53         sum(GEQ(max_end_time,ULLONG(1))) as successful_reconfiguration_requests,
  54         FLOAT(sum(GEQ(max_end_time,ULLONG(1))))/count(*) as success_rate
  55 from reconfig_status_merge
  56 group by gnb_id, TB
  57 ;
  58
  59 // ----------------------------------------------
  60 //      Merge in reconfig_reject causes and aggregate with this.
  61 DEFINE{query_name 'reconfig_status_reject_cause';
  62         max_lfta_disorder '1'; max_hfta_disorder '1';
  63         comment 'distribution of causes for DC rejection';
  64 }
  65 PARAM{ window uint; }
  66 Select gnb_id, TB,
  67         count(*) as total_reconfig_reject,
  68         sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
  69         sum(GEQ(UINT(cause_transport),0)) as count_transport,
  70         sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
  71         sum(GEQ(UINT(cause_misc),0)) as count_misc
  72 from ADDREQREJECT.sgnb_add_req_reject
  73 // where schemaId=701
  74 group by gnb_id, timestamp_ms / $window as TB
  75 ;
  76
  77 DEFINE{query_name 'reconfig_complete_reject_cause';
  78         max_lfta_disorder '1'; max_hfta_disorder '1';
  79 }
  80 PARAM{ window uint; }
  81 Select gnb_id, TB,
  82         count(*) as total_reconfig_reject,
  83         sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
  84         sum(GEQ(UINT(cause_transport),0)) as count_transport,
  85         sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
  86         sum(GEQ(UINT(cause_misc),0)) as count_misc
  87 from RECONCOMPLETE.reconfig_reject
  88 // where schemaId=102
  89 group by gnb_id, timestamp_ms / $window as TB
  90 ;
  91
  92 DEFINE{query_name 'reconfig_reject_merge';}
  93 PARAM{ window uint; }
  94 merge p1.TB : p2.TB
  95 from reconfig_status_reject_cause p1, reconfig_complete_reject_cause p2
  96 ;
  97
  98 DEFINE{query_name 'reconfig_reject_cause';
  99         max_lfta_disorder '1'; max_hfta_disorder '1';
 100 }
 101 PARAM{ window uint; }
 102 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
 103              $window/1000.0 as measurementInterval,
 104         sum(total_reconfig_refuse) as total_reconfig_refuse,
 105         sum(count_radio_network) as count_radio_network,
 106         sum(count_transport) as count_transport,
 107         sum(count_protocol) as count_protocol,
 108         sum(count_misc) as count_misc
 109 from reconfig_cause_merge
 110 group by gnb_id, TB
 111 ;
 112
 113 // ----------------------------------------------
 114
 115 DEFINE{query_name 'mod_status_refuse_cause';
 116         max_lfta_disorder '1'; max_hfta_disorder '1';
 117         comment 'distribution of causes for a sgnb modification refusal';
 118 }
 119 PARAM{ window uint; }
 120 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
 121              $window/1000.0 as measurementInterval,
 122         count(*) as total_reconfig_refuse,
 123         sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
 124         sum(GEQ(UINT(cause_transport),0)) as count_transport,
 125         sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
 126         sum(GEQ(UINT(cause_misc),0)) as count_misc
 127 from SGNBMODREFUSE.sgnb_mod_refuse
 128 // where schemaId=1401
 129 group by gnb_id, timestamp_ms / $window as TB
 130 ;
 131
 132 // ----------------------------------------------
 133 DEFINE{query_name 'release_rqd_cause';
 134         max_lfta_disorder '1'; max_hfta_disorder '1';
 135 }
 136 PARAM{ window uint; }
 137 Select gnb_id, TB,
 138         count(*) as total_reconfig_refuse,
 139         sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
 140         sum(GEQ(UINT(cause_transport),0)) as count_transport,
 141         sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
 142         sum(GEQ(UINT(cause_misc),0)) as count_misc
 143 from SGNBRELEASERQD.SgNB_release_rqd
 144 // where schemaId=1001
 145 group by gnb_id, timestamp_ms / $window as TB
 146 ;
 147
 148 DEFINE{query_name 'release_request_cause';
 149         max_lfta_disorder '1'; max_hfta_disorder '1';
 150 }
 151 PARAM{ window uint; }
 152 Select gnb_id, TB,
 153         count(*) as total_reconfig_refuse,
 154         sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
 155         sum(GEQ(UINT(cause_transport),0)) as count_transport,
 156         sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
 157         sum(GEQ(UINT(cause_misc),0)) as count_misc
 158 from RELREQ.release_req
 159 // where schemaId=801
 160 group by gnb_id, timestamp_ms / $window as TB
 161 ;
 162
 163 DEFINE{query_name 'reconfig_cause_merge';}
 164 PARAM{ window uint; }
 165 merge p1.TB : p2.TB
 166 from release_rqd_cause p1, release_request_cause p2
 167 ;
 168
 169 DEFINE{query_name 'release_cause';
 170         max_lfta_disorder '1'; max_hfta_disorder '1';
 171         comment 'distribution of the causes of a DC release';
 172 }
 173 PARAM{ window uint; }
 174 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
 175              $window/1000.0 as measurementInterval,
 176         sum(total_reconfig_refuse) as total_reconfig_refuse,
 177         sum(count_radio_network) as count_radio_network,
 178         sum(count_transport) as count_transport,
 179         sum(count_protocol) as count_protocol,
 180         sum(count_misc) as count_misc
 181 from reconfig_cause_merge
 182 group by gnb_id, TB
 183
 184