Hi All, anyone know what’s the buildQueryPlan_Count metric mean in pinot server?

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

I’m seeing thousands of buildQueryPlan_Count from server but only very few query count from broker, is this normal?

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?

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.

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 ?

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.