How to capacity plan read QPS for pinot ? Is it Servers *cores = no of queries ? Can someone guide !!

Yeah I have hone through is actually !! Read QPS number how we arrived can u elaborate?

Its your business requirement how many queries do you want to run per second. Depending on how many people have access to the dashboards/parallel users/ how many queries are fired for each dashboard

No , I mean read QPS threshold how we have set ?

That is based on some internal testing done and observed for single stage aggregation queries.

A followup question: what could be potential issue when same query takes less execution time at a times and more time at a times !!