Slow performance
A few days ago, I recreated my Signoz deployment from scratch. I'm now using a 3 sharded cluster / 1 replica each.
Ever since I did that, Signoz is unbearably slow up to the point of timing out. How can I begin troubleshooting this?
s
Srikanth Chekuri
10/27/2024, 8:56 AM
Exec into ClickHouse and share the output of this (mask any sensitive info)
Copy code
SELECT
query,
query_duration_ms
FROM clusterAllReplicas(default, system.query_log)
WHERE type = 'QueryFinish' and query_kind = 'Select' AND event_time > now() - INTERVAL 30 MINUTE
ORDER BY query_duration_ms DESC
LIMIT 20
FORMAT Vertical
d
Daniel Hilgarth
11/04/2024, 4:29 PM
Sorry for the late reply.
This query doesn't work for me, I get "Code: 701. DB:Exception Received from localhost:9000. DB:Exception Requested cluster 'default' not found. (CLUSTER_DOESNT_EXIST)"
SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.