postgres process and ps stats

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: postgres process and ps stats
Date: 2003-03-07 13:43:17
Message-ID: 3E68A1F5.9050605@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

During the execution of program entring data in a pg DB I follow what
the postmaster is doing using ps. From ps's output it seems that the
process uses about 2 minutes of CPU time before resetting the CPU time
counter to 0.

USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
postgres 5682 33.0 0.6 8292 3388 pts/1 R 22:29 0:00 postgres:
postgres TAL2 192.168.255.14 SELECT
[snip]
postgres 5682 40.6 0.6 8292 3408 pts/1 R 22:29 2:02 postgres:
postgres TAL2 192.168.255.14 INSERT

I'm trying to understand why this is.

Which part of the documentation can I read that would help me understand
why it seems one process does something for 2 minutes and then the CPU
time counter is reset to zero?

Jc

Browse pgsql-general by date

  From Date Subject
Next Message Kaare Rasmussen 2003-03-07 14:06:07 Re: My contract has been renewed
Previous Message Bruce Momjian 2003-03-07 13:40:58 Re: My contract has been renewed