Jagadeesh
10/27/2023, 10:04 PMaccount_id:
SELECT DISTINCT JSONExtractString(labels, 'account_id')
FROM signoz_metrics.time_series_v2
region:
SELECT DISTINCT(JSONExtractString(labels, 'region'))
FROM signoz_metrics.time_series_v2
WHERE (JSONExtractString(labels, 'account_id') IN {{.account_id}})
and then stack, app,..etc
The Problem was,
Signoz UI is taking lot of time to respond when i want to change the variable i.e variable drop down shows no data even though the variable was configured properly (when i try to Test Run Query i can see the required variable options).
I tried refreshing the page but i can see only the variables that are saved during Save Layout, but if i want to change the variable the drop down shows No Data.
Can anyone help on this issue.????AND metric_name LIKE 'aws_%'
This will reduce the load load an the database.