> Is there an easy and unintrusive way to get such a metric as the
> aggregated query times? And to normalize it for how much work
> happens
> to have been doing on at the time?
You'd pretty much need to do large-scale log harvesting combined with samples of query concurrency taken several times
perminute. Even that won't "normalize" things the way you want, though, since all queries are not equal in terms of
theamount of data they hit.
Given that, I'd personally take a statistical approach. Sample query execution times across a large population of
serversand over a moderate amount of time. Then apply common tests of statistical significance. This is why Heroku
hasthe opportunity to do this in a way that smaller sites could not; they have enough servers to (probably) cancel out
anyrandom activity effects.
--Josh Berkus
