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

Anaisdg January 22, 2021, 5:50pm 7

Hello @MzazM,
I haven’t received any feedback. I’ve included your question in an issue again (#3445). I’m sorry I don’t have any information. All the pushdown patterns that I’m aware of are listed in this blog:

Thank you.

Flux performance compared to similar influxQL query

Topic		Replies	Views
Which one is fast, contains vs equal expression? InfluxDB 2	1	657	March 22, 2022
Performance of contains() is very bad compared to equivalent alternatives. Same thing for regex.compile() regex , performance	3	269	July 8, 2024
Flux performance compared to similar influxQL query Fluxlang performance	5	594	December 9, 2022
findColumn results in contains Fluxlang	4	644	March 22, 2022
Contains query performance (Finding an alternative) influxdb , query , flux , performance	0	591	February 9, 2023

Impact of contains() on performance

Related topics