Slow performance A few days ago, I recreated my Si...
# support
d
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
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
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)"