X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fdebug.gsql;h=cd2ac92d8262d13932d7579723fb4c8cc314b680;hb=refs%2Fchanges%2F49%2F2549%2F2;hp=69661b60111efd21f9298c965be6661e35e53c75;hpb=7f09b7d24896c782a3e599ec35f76a42d2abd306;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/debug.gsql b/mc-core/mc/queries/debug.gsql index 69661b6..cd2ac92 100644 --- a/mc-core/mc/queries/debug.gsql +++ b/mc-core/mc/queries/debug.gsql @@ -6,7 +6,7 @@ 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 ; @@ -18,7 +18,7 @@ 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 ; @@ -30,7 +30,7 @@ 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 ; @@ -42,7 +42,7 @@ 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