Re: Autoanalyze CPU usage

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: Habib Nahas <habibnahas(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Autoanalyze CPU usage
Date: 2017-12-20 08:24:09
Message-ID: CANNMO+LOfMCpWvddU_xJacxu3HEzUMZsYUuyvBD+Vu_Dy5taMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Dec 19, 2017 at 7:47 PM, Habib Nahas <habibnahas(at)gmail(dot)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?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Habib Nahas 2017-12-20 14:38:59 Re: Autoanalyze CPU usage
Previous Message Laurenz Albe 2017-12-20 07:15:39 Re: Autoanalyze CPU usage