Based on the online help of JavaMelody (http://javamelody.org/demo/monitoring?resource=help/help.html), the number of hits equal to number of executions
I am noticing in my SQL monitoring, that i have Hits by parent request: 0.32 or 0.45 on some statements. How does this information translate ? I would expect that the hit number is an integer with a minimum value of 1.
The question is about the javamelody statistics on http and sql requests.
Imagine that you have a http request "/awesome" executing a sql request "select 1 from awesome" 3 times in a row. Then javamelody stats for "/awesome" would display a child sql request "select 1 from awesome" with a value of "hits by parent" of "3.00".
So, a value of "hits [of the request] by parent [request]" of "0.32" for another sql request means that the parent request has executed the sql request approximately 1 time for 3 executions of the parent request. Perhaps the first execution of the parent request executed the sql request once and put the result in cache and the second and third executions of the parent request used the cache. Or perhaps, given some input data which may be valid or may be rejected right away, the sql request is sometimes executed by the parent request and sometimes it is not executed by the parent request.
Whatever the reason, 0.32 "hits by parent" means that there is 1 execution of the sql request for 32% of the executions of the parent request.