I think there is something wrong with the function contains(). Query 1 does not use contains() and takes 0.15s. from(bucket: "short") |> range(start: v.timeRangeStart,stop: v.timeRangeStop) |> filter(fn: (r)=> r["_measurement"] == "Phasor") |> filter(fn: (r) => r["UID"] =~ /RepDev0…

Hi finally, I found online a workaround that can be used to replace contains when using grafana. Here it is: Grafana + InfluxDB Flux - query for displaying multi-select variable inputs - InfluxDB - Grafana Labs Community Forums

Impact of contains() on performance

InfluxDB 2

MzazM January 22, 2021, 5:07pm 6

Hello, we keep having issues with the poor performance of contains(),
do you you know if there is a possibility that it will ever be a push-down function like filter and others?

How to fetch data from SQL and use it as filter condition

Topic		Replies	Views
Which one is fast, contains vs equal expression? InfluxDB 2	1	550	March 22, 2022
Performance of contains() is very bad compared to equivalent alternatives. Same thing for regex.compile() regex , performance	3	134	July 8, 2024
Flux performance compared to similar influxQL query Fluxlang performance	5	570	December 9, 2022
Contains query performance (Finding an alternative) influxdb , query , flux , performance	0	555	February 9, 2023
Large Filter Clause Performance InfluxDB 2 influxdb , schema , query , flux , performance	6	647	June 20, 2023

Impact of contains() on performance

Related topics