I think this is a clickhouse setting we enabled. Do you really need your queries to be running for more than 1 min? cc @Vishal Sharma
d
Daniël Boelman
04/17/2023, 12:01 PM
Yes, we have a lot of data we are querying over. Is this a setting I could configure?
a
Ankit Nayan
04/17/2023, 12:10 PM
Is this a setting I could configure?
I will let @Vishal Sharma 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.
d
Daniël Boelman
04/17/2023, 12:19 PM
SELECT quantile(0.99)(durationNano) as p99,
name,
toDateTime(toStartOfMinute(timestamp)) AS ts
FROM
()
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
SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.