| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org> |
| Cc: | Mitch Vincent <mitch(at)huntsvilleal(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: system usage stats (Was: Re: Why Not MySQL? ) |
| Date: | 2000-05-04 05:24:49 |
| Message-ID: | 22646.957417889@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The Hermit Hacker <scrappy(at)hub(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-05-04 05:36:11 | Re: system usage stats (Was: Re: Why Not MySQL? ) |
| Previous Message | The Hermit Hacker | 2000-05-04 05:18:10 | system usage stats (Was: Re: Why Not MySQL? ) |