| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Matthew Musgrove <mmusgrove(at)emortgagelogic(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Weirdness with the stats collector process |
| Date: | 2016-07-25 20:50:55 |
| Message-ID: | dde4a733-35f2-4267-ec9e-b63ef18d11fb@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-07-25 23:55:34 | Re: Re: [GENERAL] A simple extension immitating pg_notify |
| Previous Message | Tom Lane | 2016-07-25 20:20:52 | Re: Weirdness with the stats collector process |