Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7D1AA9FB33C for ; Thu, 8 Feb 2007 17:24:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 42070-10 for ; Thu, 8 Feb 2007 17:24:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 242329FB33B for ; Thu, 8 Feb 2007 17:24:24 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l18LONlH019936; Thu, 8 Feb 2007 16:24:23 -0500 (EST) To: Benjamin Minshall cc: pgsql-performance@postgresql.org Subject: Re: stats collector process high CPU utilization In-reply-to: <45CB9330.3000603@intellicon.biz> References: <45CB5441.1040707@intellicon.biz> <21013.1170955076@sss.pgh.pa.us> <45CB5D06.7090004@intellicon.biz> <7994.1170960391@sss.pgh.pa.us> <45CB9330.3000603@intellicon.biz> Comments: In-reply-to Benjamin Minshall message dated "Thu, 08 Feb 2007 16:16:32 -0500" Date: Thu, 08 Feb 2007 16:24:22 -0500 Message-ID: <19935.1170969862@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/92 X-Sequence-Number: 23146 Benjamin Minshall writes: > Tom Lane wrote: >> Can you gather some info about what it's doing? >> strace'ing the stats collector might prove interesting, also if you have >> built it with --enable-debug then oprofile results would be helpful. > I will gather some strace info later today when I have a chance to > shutdown the server. I don't see why you'd need to shut anything down. Just run strace -p stats-process-ID for a few seconds or minutes (enough to gather maybe a few thousand lines of output). regards, tom lane