system usage stats (Was: Re: Why Not MySQL? )
От | The Hermit Hacker |
---|---|
Тема | system usage stats (Was: Re: Why Not MySQL? ) |
Дата | |
Msg-id | Pine.BSF.4.21.0005040216470.92638-100000@thelab.hub.org обсуждение исходный текст |
Ответ на | Re: Why Not MySQL? ("Mitch Vincent" <mitch@huntsvilleal.com>) |
Ответы |
Re: system usage stats (Was: Re: Why Not MySQL? )
|
Список | 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@hub.org secondary: scrappy@{freebsd|postgresql}.org
В списке pgsql-hackers по дате отправления: