There are already some tools that can respond to the majority of your questions:
- Aolserver's nstelemetry.adp
- the standard log analyzer suggesteded by OpenACS
- and Cassandracle Unfortunately nstelemetry.adp doesn't run anymore on my OpenACS 4.x servers.