#support

Efficient Query Writing for Dashboard

TLDR Vishnu asked for optimized query writing for dashboard performance. Ankit explained the efficiency differences between promQL and QueryBuilder/Clickhouse SQL queries.

Powered by Struct AI
4
4mo
Solved
Join the chat
May 09, 2023 (4 months ago)
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
12:51 PM
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?
Ankit
Photo of md5-dbe7088320fe1d922707613e02f3420d
Ankit
03:39 PM
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.
03:40
Ankit
03:40 PM
QueryBuilder and Clickhouse SQL queries should be much faster as they use the clickhouse engine for processing and do not bring raw data to query-service
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
04:16 PM
Thanks Ankit