This message was deleted Apache Druid #troubleshooting

Join Slack

This message was deleted.

# troubleshooting

Slackbot

02/27/2023, 3:55 AM

This message was deleted.

kfaraz

02/27/2023, 4:41 AM

Are you using the prometheus metrics emitter? You should be able to use the metric

query/time

to get max/min/avg query times. Docs: https://druid.apache.org/docs/latest/operations/metrics.html#query-metrics

추호관

02/27/2023, 5:15 AM

@kfaraz yes i am using query/time metric but confused how to use query_time_bucket to get max time

Luiz Augusto

02/27/2023, 11:20 AM

query/time

value is histogram type, so the wholepoint is to use for a heatmap type chart or to get quantiles from it. As the data is bucketized, you can’t get a min/max value out it. For quantiles use:

Copy code

histogram_quantile(0.5, sum(rate(query_time_bucket{druid_service="druid/broker"}[$__interval])) by (le)) 
histogram_quantile(0.95, sum(rate(query_time_bucket{druid_service="druid/broker"}[$__interval])) by (le))

For a heatmap use something like:

Copy code

sum by(le) (increase(query_time_bucket{druid_service="druid/broker"}[$__interval]))

Luiz Augusto

02/27/2023, 11:27 AM

with the heatmap view you can see what’s the window range for most your queries and even their max buckets. So I can tell I have very few awful queries in the 2-5 min range, but they are super rare. And even during the highest usage most my queries where < 100 ms

추호관

02/27/2023, 11:39 AM

@Luiz Augusto Thanks for help

you can't get a min/max value

yes… its bucket so i cant get min max value got it

3 Views

Open in Slack

Previous Next