Re: Weirdness with the stats collector process - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Weirdness with the stats collector process
Date
Msg-id dde4a733-35f2-4267-ec9e-b63ef18d11fb@aklaver.com
Whole thread Raw
In response to Weirdness with the stats collector process  (Matthew Musgrove <mmusgrove@emortgagelogic.com>)
List pgsql-general
On 07/25/2016 11:50 AM, Matthew Musgrove wrote:
> One of our instances has been behaving -- oddly. Most queries are
> blazing fast. It appears to just be some of the stat views that are slow.
>

>
> Does anyone have any suggestions on how to:
>  - see what the statistics collector is doing?
>  - tell the postmaster to give the statistics collector the up to date
> config?
>  - get stats working without restarting the instance? (I am not yet sure
> when that can happen but it would have to be scheduled [in advance] to
> occur during an after hours maintenance window.


Anything in the system logs that might help?

>
> Thanks in advance,
> Matt
>
> --


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Weirdness with the stats collector process
Next
From: Adrian Klaver
Date:
Subject: Re: Re: [GENERAL] A simple extension immitating pg_notify‏