Hi, What is the suggested/optimised way to write queries for dashboard? I saw better performance with native clickhouse queries compared to others. Do we have any benchmark regarding this?

promQL

queries are not efficient as they pull raw data from clickhouse and then do the processing in-memory. It works in the same way Prometheus remote-read works and it is supposed to be inefficient by design.

Thanks @Ankit Nayan