Skip site navigation (1) Skip section navigation (2)

Re: freebsd + postgresql 8.3.3 = 100% of cpu usage onstats collector?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: Rodrigo Gonzalez <rjgonzale(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: freebsd + postgresql 8.3.3 = 100% of cpu usage onstats collector?
Date: 2008-06-30 08:58:32
Message-ID: 20080630085832.GA10876@depesz.com (view raw or flat)
Thread:
Lists: pgsql-general
On Sun, Jun 29, 2008 at 05:13:59PM -0400, Bill Moran wrote:
> Use the kdump utility to convert the ktrace.out file to something usable.
> Something like "kdump > ktrace.txt" will probably get you what you want,
> assuming your ktrace file is ktrace.out.

ok. did it. in about 7 seconds, i got 250mb of ktrace.out.
ktrace.txt is 176 megabytes.
content of this is pretty simple:
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)
 58241 postgres RET   poll -1 errno 4 Interrupted system call
 58241 postgres CALL  poll(0x7fffffffd4e0,0x1,0x7d0)

should i make the ktrace.txt available, or should i do something else to
help you ( i mean, the pg-hackers community) diagnose the issue?

Best regards,

depesz


In response to

Responses

pgsql-general by date

Next:From: kartikDate: 2008-06-30 09:55:45
Subject: Query
Previous:From: Craig RingerDate: 2008-06-30 07:00:12
Subject: Re: re-using cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group