I run a simple query using a filter on the date column, plus _field
and _measurement
. The query runs nearly 10 minutes, which is super slow. Is there an automated index on these columns, or any way to speed this up?
Here the query:
from(bucket: "xyz")
|> range(start: 2024-09-01, stop: 2024-10-01)
|> filter(
fn: (r) =>
r._field == "value" and
contains(value: r._measurement, set: ["aa", "bb", "cc", "dd", "ee"])
)
Thanks for any hint.