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
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 |