Adding MC-NIB support

[ric-app/mc.git] / mc-core / mc / queries / throughput.gsql

diff --git a/mc-core/mc/queries/throughput.gsql b/mc-core/mc/queries/throughput.gsql
index 0e5c9eb..6e61502 100644 (file)
--- a/mc-core/mc/queries/throughput.gsql
+++ b/mc-core/mc/queries/throughput.gsql
@@ -1,5 +1,7 @@
 DEFINE{query_name 'throughput_ue';
+       extra_keys 'TS';
        max_lfta_disorder '1'; max_hfta_disorder '1';
+       comment 'throughput experienced by UE over a measurement interval.   *Active* throughput is throughput while actively downloading, *average* averages bytes transfered over the measurement interval';
 }
 PARAM{ window uint; }
 select ($window*(TB+1))/1000 as TS, e_RAB_ID, UE_ID, GNB_ID,
@@ -26,7 +28,7 @@ select ($window*(TB+1))/1000 as TS, e_RAB_ID, UE_ID, GNB_ID,
                  , 1) ) as max_throughput
 
 from RATDATAUSAGE.rat_data_usage
-where schemaId=1501
+//where schemaId=1501
 group by e_RAB_ID, id_SgNB_UE_X2AP_ID as UE_ID, gnb_id as GNB_ID, timestamp_ms/$window as TB
 ;
 
@@ -36,7 +38,9 @@ group by e_RAB_ID, id_SgNB_UE_X2AP_ID as UE_ID, gnb_id as GNB_ID, timestamp_ms/$
 
 
 DEFINE{query_name 'throughput_rollup';
+       extra_keys 'TS';
        max_lfta_disorder '1'; max_hfta_disorder '1';
+       comment 'statistics on the per-UE throughput';
 }
 PARAM{ window uint; }
 select TS, e_RAB_ID, GNB_ID,
@@ -56,6 +60,7 @@ group by TS, e_RAB_ID, GNB_ID
 
 DEFINE{query_name 'throughput_gnb';
        max_lfta_disorder '1'; max_hfta_disorder '1';
+       comment 'throughput experienced by a GNB over a measurement interval.   *Active* throughput is throughput while actively downloading, *average* averages bytes transfered over the measurement interval';
 }
 PARAM{ window uint; }
 select ($window*(TB+1))/1000 as TS, e_RAB_ID, GNB_ID,
@@ -92,7 +97,7 @@ select ($window*(TB+1))/1000 as TS, e_RAB_ID, GNB_ID,
                  , 1) ), .95)
 
 from RATDATAUSAGE.rat_data_usage
-where schemaId=1501
+//where schemaId=1501
 group by e_RAB_ID, gnb_id as GNB_ID, timestamp_ms/$window as TB