Re: system usage stats (Was: Re: Why Not MySQL? )
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: The Hermit Hacker <scrappy@hub.org>
Cc: Mitch Vincent <mitch@huntsvilleal.com>, pgsql-hackers@postgresql.org
Date: 2000-05-04T05:24:49Z
Lists: 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