Re: High CPU usage of stats collector

[Michael Paquier <michael.paquier@xxxxxxxxx>]

On Fri, Apr 5, 2013 at 7:44 PM, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:

On Sun, Mar 31, 2013 at 11:44 PM, komunca <komunca@xxxxxxxxx> wrote:
> On my db server I have noticed a very high CPU usage of process:
> *postgres: stats collector process*
>
> It is not below 50% of CPU. (Info from htop).
>
> What is best way to decrease CPU usage of this process?

Do you by any chance have a large number of databases, and/or a large
number of objects in your databases (tables or indexes)?

Could you output the result of this query?

SELECT count(*) FROM pg_class;

--
Michael