Yeah - but you can safely ignore all those "maximum" statistics. The machine was heavily swapping, meaning all sorts of hell was breaking loose.
Is there a way to clear the statistics counters without restarting the process?
Brian
> On Mar 13, 2017, at 11:10 AM, John M Knoeller <johnkn@xxxxxxxxxxx> wrote:
>
> To be clear. of the 20227 forked queries, the slowest was 19 seconds. That's 19 seconds forking, there is no stat for how long the child was alive and handling the query. The child knows how long it spent, and that info goes into the log, but the top level collector is only recording how long it spent forking the child.
>
> Also that 19 seconds might have been a child that was OOM killed and never finish forking.
>
> -tj
>
>
>
|
![[Computer Systems Lab]](http://www.cs.wisc.edu/pics/csl_logo.gif){kind=logo}