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.
May 09, 2023 (4 months ago)
I saw better performance with native clickhouse queries compared to others.
Do we have any benchmark regarding this?
promQLqueries 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.
Indexed 825 threads (61% resolved)
Translating PromQL Query to ClickHouse Query
Romario needs help translating a PromQL query to ClickHouse. Srikanth provides the translation but it returns no data. Issue found in the original data.
Combining ClickHouse Queries and Query Builder Limitations
Harshith.R.S asked how to combine two ClickHouse queries. Srikanth suggested using subqueries, and vishal-signoz provided an example. Harshith.R.S later mentioned hitting query builder panel limits, and vishal-signoz recommended upgrading to a paid plan for more features.
Dashboard Load Issues and Possible Solutions
Al experiences dashboard loading issues since updating to `0.18.1`. Srikanth believes the issue is not version related and suggests examining queries, memory resources, and server distribution for improvements.