This message was deleted.
# troubleshootings
Slackbot
03/26/2023, 9:30 PMThis message was deleted.
s
Shyam
03/26/2023, 9:31 PMI see that for my queries, the query/segment/time takes the most time on the historical. What generally causes query segment time spikes and how can it be brought down?
j
John Kowtko
03/26/2023, 11:04 PMHigh segment scan time could be due to scanning the bulk of the data in the segment. Are these queries "heavy" group by queries that do not have highly selective filters on them?
Is there a high wait time as well?
s
Shyam
03/26/2023, 11:34 PMYeah most of the queries don't have filters on them, but the total datasource size isn't large (~150GB)
Is there a way to improve the speed of these queries? Would increasing the heap help? We have heap set to 10g currently
f
FJ
03/26/2023, 11:34 PMare you using Druid 25?
s
Shyam
03/26/2023, 11:34 PMWait time is negligible. Almost all of the query time is spent on query segment time
Shyam
03/26/2023, 11:34 PMYes I'm using 25
f
FJ
03/26/2023, 11:36 PMthere’s no easy answer to ‘why are queries slow’ - it can be because the data model is incorrect, the query itself is written in an inefficient way, there’s insufficient hardware, etc
FJ
03/26/2023, 11:36 PMcan you post the query you are trying to run and details about your cluster?
v
Vijay Narayanan
03/27/2023, 3:38 AMYou can also book a time in the POC clinic https://calendly.com/druidcommunity/clinic-poc
2 Views