From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Mitch Vincent <mitch(at)huntsvilleal(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | system usage stats (Was: Re: Why Not MySQL? ) |
Date: | 2000-05-04 05:18:10 |
Message-ID: | Pine.BSF.4.21.0005040216470.92638-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 3 May 2000, Mitch Vincent wrote:
> > So, may I have the envelope please? What's the timings?
>
> 6.5.3:
>
> StartTransactionCommand
> query: select * from applicants as a,applicants_states as s where
> a.firstname ~* '^mitch' and s.rstate='AL' and s.app_id=a.app_id limit 10
> offset 0;
> ProcessQuery
> ! 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]?
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-05-04 05:24:49 | Re: system usage stats (Was: Re: Why Not MySQL? ) |
Previous Message | Thomas Lockhart | 2000-05-04 05:15:56 | Re: AW: Why Not MySQL? |