Re: stats collector process high CPU utilization - Mailing list pgsql-performance

From Tom Lane
Subject Re: stats collector process high CPU utilization
Date
Msg-id 19935.1170969862@sss.pgh.pa.us
Whole thread Raw
In response to Re: stats collector process high CPU utilization  (Benjamin Minshall <minshall@intellicon.biz>)
Responses Re: stats collector process high CPU utilization  (Benjamin Minshall <minshall@intellicon.biz>)
List pgsql-performance
Benjamin Minshall <minshall@intellicon.biz> 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

pgsql-performance by date:

Previous
From: Benjamin Minshall
Date:
Subject: Re: stats collector process high CPU utilization
Next
From: Benjamin Minshall
Date:
Subject: Re: stats collector process high CPU utilization