Clickhouse Query Timeout in SigNoz Dashboard
TLDR Daniel experienced query timeouts in SigNoz dashboard. vishal-signoz confirmed it's a non-configurable 60s limit, but created a GitHub issue for adding the feature.
Apr 17, 2023 (8 months ago)
I will let vishal-signoz reply on this.
> we have a lot of data we are querying over.
Is this a standard APM query or some other use case? Can you share a sample query (in simple English or SQL)? We might have ways to make it performant.
SELECT quantile(0.99)(durationNano) as p99,
toDateTime(toStartOfMinute(timestamp)) AS ts
WHERE( timestamp >= start_t
AND timestamp <= end_t
GROUP BY name,ts
ORDER BY p99 DESC
this is the basic query, it contains some more filtering to make it specific for a cluster and remove some unwanted data
Currently it’s not configurable.
Created an issue to allow it to be configurable via env variable, Track here: https://github.com/SigNoz/signoz/issues/2582
do you have serviceName in the filters? The query will be faster with ServiceName.
Indexed 1023 threads (61% resolved)
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.
Issues with SigNoz Setup and Data Persistence in AKS
Vaibhavi experienced issues setting up SigNoz in AKS, and faced data persistence issues after installation. Srikanth provided guidance on ClickHouse version compatibility and resource requirements, helping Vaibhavi troubleshoot and resolve the issue.
Incorrect Alert Firing Issue in Threshold Condition
Harshith.R.S is experiencing an issue with alerts firing when the value is above the threshold. The issue remains unresolved after trying different query modifications suggested by Amol.
Debugging and Optimizing Slow Signoz Dashboard
Div reported slow Signoz dashboard and errors. Srikanth suggested creating a materialized column and adding filters to speed up queries. vishal-signoz confirmed the suggested approach.
Adjusting Dashboard Details with Clickhouse Query and Time Dropdown
Harshith.R.S asked how to change dashboard details with clickhouse query based on time dropdown. Srikanth provided a solution using time template variables in the query.