Slackbot
04/17/2023, 11:50 AMAnkit Nayan
Daniël Boelman
04/17/2023, 12:01 PMAnkit Nayan
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.
Daniël Boelman
04/17/2023, 12:19 PMSELECT 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 dataVishal Sharma
04/17/2023, 12:28 PMDaniël Boelman
04/17/2023, 12:30 PMAnkit Nayan
this is the basic query, it contains some more filtering to make it specific for a cluster and remove some unwanted datado you have serviceName in the filters? The query will be faster with ServiceName.
Daniël Boelman
04/17/2023, 12:34 PM