Adding 60 queries, I get a ‘Request URL is too long’ response, how can I simplify the queries?
The sensor series names are
sensor.power_1_0_1
sensor.power_2_0_1
Welcome
Why do you have 60 queries
I created one query for each panel, 60 panels, 60 queries.
How can I simplify the queries?
Preferably, one query for all sensors starting with ‘sensor.power_’?
-
Is this using influxdb and flux query language or influxql?
-
Do you have tags associatied with each data point/measurement
-
Do you need to see 60 panels for comparison purposes?
You could simplify yhings by using one panel for all of them with a dropndown to select one sensor at a time?
- InfluxDB on an RPi 4B 8GB with SSD
Home Assistant 2023.4.6
Supervisor 2023.04.1
Operating System 10.0
Frontend 20230411.1 - latest
InfluxDB version: 4.6.0 - No tags just yet, reliable reading of each panel was achieved only yesterday
- Yes, seeing all 60 panels will enable me to detect trends and outliers
1 Like
Tags are indexed fields are not. It might help performance
I think the one panel approach might be the best way to see trends and outliers in one visualization . Maybe create another dashboard with one panel one query to see if it is worth it.
60 is not scaling properly