Re: system usage stats (Was: Re: Why Not MySQL? ) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: system usage stats (Was: Re: Why Not MySQL? )
Date
Msg-id 22646.957417889@sss.pgh.pa.us
Whole thread Raw
In response to system usage stats (Was: Re: Why Not MySQL? )  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: system usage stats (Was: Re: Why Not MySQL? )  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
The Hermit Hacker <scrappy@hub.org> writes:
>> ! system usage stats:
>> !       0.436792 elapsed 0.275139 user 0.157033 system sec
>> !       [0.283135 user 0.173026 sys total]
>> !       0/0 [0/0] filesystem blocks in/out
>> !       0/149 [0/332] page faults/reclaims, 0 [0] swaps
>> !       0 [0] signals rcvd, 0/0 [2/2] messages rcvd/sent
>> !       0/8 [2/9] voluntary/involuntary context switches

> How is this to be read?  I'm looking at it, and reading it as:

>   0 - voluntary
>   8 - involuntary

> But what about the [2/9]?

I believe the numbers outside brackets are for the particular query
cycle, and the ones in brackets are total for the process (ie, total
since backend start).

I didn't design the printout format ;-) ... not real sure what the
point is of printing the total-since-start numbers ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: system usage stats (Was: Re: Why Not MySQL? )
Next
From: The Hermit Hacker
Date:
Subject: Re: system usage stats (Was: Re: Why Not MySQL? )