On Tue, Dec 19, 2017 at 7:47 PM, Habib Nahas wrote:
> Hi,
>
> We operate an RDS postgres 9.5 instance and have periodic CPU spikes to
> 100%. These spikes appear to be due to autoanalyze kicking on our larger
> tables.
>
How did you draw such conclusion? How did you find that autoanalyze is the
Thanks for confirming that it is the end timestamp, the doc wasn't quite
clear if it was the start or end.
There is a gap in our monitoring that makes diagnosis of such events very
difficult after the fact. Something like a 10-sec periodic dump of
pg_stat_activity along with a similar dump of pg_t
