Postgres Pro
Downloads
Home   >   mailing lists

Re: Autoanalyze CPU usage - Mailing list pgsql-performance

From Nikolay Samokhvalov
Subject Re: Autoanalyze CPU usage
Date
Msg-id CANNMO+LOfMCpWvddU_xJacxu3HEzUMZsYUuyvBD+Vu_Dy5taMA@mail.gmail.com
Whole thread Raw
In response to Autoanalyze CPU usage  (Habib Nahas <habibnahas@gmail.com>)
List pgsql-performance
Tree view
On Tue, Dec 19, 2017 at 7:47 PM, Habib Nahas <habibnahas@gmail.com> 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 reason of CPU spikes? 

pgsql-performance by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Autoanalyze CPU usage
Next
From: Habib Nahas
Date:
Subject: Re: Autoanalyze CPU usage