X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fdebug.gsql;h=cd2ac92d8262d13932d7579723fb4c8cc314b680;hb=0eb834e581b25c0ac0a657b1b7d8bb70fe4d2aa9;hp=5d92fb1b6da6a611e996e161011a18f7dd3f8481;hpb=31d238a2cba18b87e05a7d9b4820db2c5186c658;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/debug.gsql b/mc-core/mc/queries/debug.gsql index 5d92fb1..cd2ac92 100644 --- a/mc-core/mc/queries/debug.gsql +++ b/mc-core/mc/queries/debug.gsql @@ -1,40 +1,48 @@ -DEFINE{ query_name 'reconfig_all_debug'; } +DEFINE{ query_name 'reconfig_all_debug'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select 'reconfig_all_debug' as name, count(*) as cnt, ($window*(TB+1))/1000 as TS, $window/1000.0 as measurementInterval from RECONCOMPLETE.reconfig_all -where schemaId=103 +// where schemaId=103 group by timestamp_ms / $window as TB ; -DEFINE{ query_name 'reconfig_success_debug'; } +DEFINE{ query_name 'reconfig_success_debug'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select 'reconfig_success_debug' as name, count(*) as cnt, ($window*(TB+1))/1000 as TS, $window/1000.0 as measurementInterval from RECONCOMPLETE.reconfig_success -where schemaId=101 +// where schemaId=101 group by timestamp_ms / $window as TB ; -DEFINE{ query_name 'reconfig_reject_debug'; } +DEFINE{ query_name 'reconfig_reject_debug'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select 'reconfig_reject_debug' as name, count(*) as cnt, ($window*(TB+1))/1000 as TS, $window/1000.0 as measurementInterval from RECONCOMPLETE.reconfig_reject -where schemaId=102 +// where schemaId=102 group by timestamp_ms / $window as TB ; -DEFINE{ query_name 'dc_release_debug'; } +DEFINE{ query_name 'dc_release_debug'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select 'dc_release_debug' as name, count(*) as cnt, ($window*(TB+1))/1000 as TS, $window/1000.0 as measurementInterval from CONRELEASE.dc_release -where schemaId=201 +// where schemaId=201 group by timestamp_ms / $window as TB