TLDR Vishnu asked for optimized query writing for dashboard performance. Ankit explained the efficiency differences between promQL and QueryBuilder/Clickhouse SQL queries.
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.
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
Indexed 1061 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI