Priyank Bagrecha
10/28/2022, 7:45 AMSlow query: request handler processing time: 518, send response latency: 0, total time to handle request: 518
Processed requestId=1198,table=offlinebookingwide_main_OFFLINE,segments(queried/processed/matched/consumingQueried/consumingProcessed/consumingMatched/invalid/limit/value)=9/9/9/-1/0/0/0/0/0,schedulerWaitMs=508,reqDeserMs=0,totalExecMs=63,resSerMs=0,totalTimeMs=571,minConsumingFreshnessMs=-1,broker=Broker_pinot-offline-broker-1.pinot-offline-broker-headless.de-nrt-pinot.svc.cluster.local_8099,numDocsScanned=15836,scanInFilter=0,scanPostFilter=981832,sched=FCFS,threadCpuTimeNs(total/thread/sysActivity/resSer)=0/0/0/0
Processed requestId=1199,table=offlinebookingwide_main_OFFLINE,segments(queried/processed/matched/consumingQueried/consumingProcessed/consumingMatched/invalid/limit/value)=6/6/6/-1/0/0/0/0/0,schedulerWaitMs=510,reqDeserMs=1,totalExecMs=59,resSerMs=0,totalTimeMs=570,minConsumingFreshnessMs=-1,broker=Broker_pinot-offline-broker-1.pinot-offline-broker-headless.de-nrt-pinot.svc.cluster.local_8099,numDocsScanned=10476,scanInFilter=0,scanPostFilter=649512,sched=FCFS,threadCpuTimeNs(total/thread/sysActivity/resSer)=0/0/0/0
Slow query: request handler processing time: 571, send response latency: 0, total time to handle request: 571
Slow query: request handler processing time: 570, send response latency: 0, total time to handle request: 570
Processed requestId=1197,table=offlinebookingwide_main_OFFLINE,segments(queried/processed/matched/consumingQueried/consumingProcessed/consumingMatched/invalid/limit/value)=10/10/10/-1/0/0/0/0/0,schedulerWaitMs=501,reqDeserMs=1,totalExecMs=72,resSerMs=0,totalTimeMs=574,minConsumingFreshnessMs=-1,broker=Broker_pinot-offline-broker-1.pinot-offline-broker-headless.de-nrt-pinot.svc.cluster.local_8099,numDocsScanned=17615,scanInFilter=0,scanPostFilter=1092130,sched=FCFS,threadCpuTimeNs(total/thread/sysActivity/resSer)=0/0/0/0
Slow query: request handler processing time: 574, send response latency: 0, total time to handle request: 574
and seeing query latency in seconds on the client side. neither broker or server cpu is more than 10-15%. what should i look at to try and debug slow query performance?