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