https://pinot.apache.org/ logo
#general
Title
# general
t

troywinter

08/23/2021, 6:34 AM
Hi All, anyone know what’s the buildQueryPlan_Count metric mean in pinot server?
x

Xiang Fu

08/23/2021, 9:07 AM
This is a timer to measure the latency of query phases,
buildQueryPlan
is just one phase.
buildQueryPlan_Count
is published as the count of the metrics, you can ignore it as you already have query count metrics
See
org.apache.pinot.common.metrics.ServerQueryPhase.java
for server query phase references
t

troywinter

08/23/2021, 9:53 AM
I’m seeing thousands of buildQueryPlan_Count from server but only very few query count from broker, is this normal?
m

Mayank

08/23/2021, 3:35 PM
Hmm, for a single server, the count should match the broker. However, if there are multiple servers the aggregation across servers would be large. How many servers do you have?
t

troywinter

08/24/2021, 3:11 AM
I have 4 servers, looks like the query count on broker is not consistent with buildQueryPlan_Count, I only get like 50 count per 5 minutes on each broker, but got more than 1000 buildQueryPlan_Count per 5 minutes on each server.
x

Xiang Fu

08/24/2021, 5:33 AM
Hmm, each broker query will be scatter to all the servers, so your server may have more. Do you have other systems like presto running ?
t

troywinter

08/24/2021, 7:00 AM
No, we have identified there are 1000s queries due an issue in our monitor system, looks like the query count in broker didn’t reflect this.