Postgres Professional
   

Re: Question on pgbench output

From: David Kerr
Subject: Re: Question on pgbench output
Date: ,
Msg-id: 20090405040611.GA27947@mr-paradox.net
(view: Whole thread, Raw)
In response to: Re: Question on pgbench output  (Greg Smith)
List: pgsql-performance

Tree view

Question on pgbench output  (David Kerr, )
 Re: Question on pgbench output  (Tom Lane, )
  Re: Question on pgbench output  (David Kerr, )
   Re: Question on pgbench output  (Tom Lane, )
 Re: Question on pgbench output  (Scott Marlowe, )
 Re: Question on pgbench output  (Greg Smith, )
  Re: Question on pgbench output  (Tom Lane, )
   Re: Question on pgbench output  (David Kerr, )
    Re: Question on pgbench output  (David Kerr, )
    Re: Question on pgbench output  (Simon Riggs, )
     Re: Question on pgbench output  (Tom Lane, )
      Re: Question on pgbench output  (David Kerr, )
       Re: Question on pgbench output  (Tom Lane, )
   Re: Question on pgbench output  (Greg Smith, )
    Re: Question on pgbench output  (David Kerr, ) 
On Fri, Apr 03, 2009 at 10:35:58PM -0400, Greg Smith wrote:
- On Fri, 3 Apr 2009, Tom Lane wrote:
-
- and a bunch of postmaster ones, with "-c" (or by hitting "c" while top is
- running) you can even see what they're all doing.  If the pgbench process
- is consuming close to 100% of a CPU's time, that means the results it's
- giving are not valid--what you're seeing in that case are the limitations
- of the testing program instead.

Looks pretty good to me. not too much mem or CPU.

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 4241 postgres  20   0  9936 2652 1680 S    0  0.1   0:00.02 pgbench
 4241 postgres  20   0 22948  10m 1708 R    4  0.3   0:00.46 pgbench
 4241 postgres  20   0 26628  14m 1708 R    5  0.3   0:00.96 pgbench
 4241 postgres  20   0 29160  15m 1708 R    5  0.4   0:01.44 pgbench
 4241 postgres  20   0 30888  16m 1708 R    4  0.4   0:01.86 pgbench
 4241 postgres  20   0 31624  17m 1708 R    5  0.4   0:02.34 pgbench
 4241 postgres  20   0 32552  18m 1708 R    5  0.5   0:02.82 pgbench
 4241 postgres  20   0 33160  18m 1708 R    5  0.5   0:03.28 pgbench
 4241 postgres  20   0 33608  18m 1708 R    4  0.5   0:03.70 pgbench
 4241 postgres  20   0 34056  19m 1708 R    4  0.5   0:04.08 pgbench
 4241 postgres  20   0 34056  19m 1708 R    4  0.5   0:04.52 pgbench
 4241 postgres  20   0 34376  19m 1708 R    4  0.5   0:04.98 pgbench
 4241 postgres  20   0 34536  19m 1708 R    4  0.5   0:05.42 pgbench
 4241 postgres  20   0 34536  19m 1708 R    5  0.5   0:05.88 pgbench
 4241 postgres  20   0 34664  19m 1708 R    5  0.5   0:06.34 pgbench
 4241 postgres  20   0 34664  19m 1708 R    5  0.5   0:06.82 pgbench
 4241 postgres  20   0 34664  19m 1708 R    4  0.5   0:07.26 pgbench
 4241 postgres  20   0 34664  20m 1708 R    4  0.5   0:07.72 pgbench
 4241 postgres  20   0 34664  20m 1708 R    4  0.5   0:08.12 pgbench

Dave

pgsql-performance by date:

Previous:
From: Simon Riggs
Date:
Subject: Re: Question on pgbench output
Next:
From: Tom Lane
Date:
Subject: Re: Question on pgbench output