system usage stats (Was: Re: Why Not MySQL? )

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

In response to

Responses

Browse pgsql-hackers by date

  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?