Re: Autoanalyze CPU usage

2017-12-20 Thread Habib Nahas
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

Re: Autoanalyze CPU usage

2017-12-20 Thread Nikolay Samokhvalov
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