Hello dear colleagues, here I am again 😅 Regarding the following query, I have 2 questions: • indexing both

net

and

inet

columns will yield better performance as they are the search needle in this query? • This query runs extremely fast on QuestDB UI (average of 500ms including network delay), but in Grafana is taking around 10 secs. I’m wondering if this difference is only “plot time” of points on chart by Grafana…

SELECT
  $__time(timestamp),
  "as" || ' via ' || "host" AS metric,
  sum(value)/($__interval_ms/60000) AS "bps"
FROM "bytinDstNet"
WHERE
  $__timeFilter(timestamp) AND
  net in($net) AND
  inet in($inet)
SAMPLE BY $__interval FILL(0);

Hi Gabriel, The database will use only a single index in this case. To see the execution plan you can use EXPLAIN statement:

Thanks @Andrey Pechkurov , will check!