Re: Identify root-cause for intermittent spikes

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Sengottaiyan T <techsenko(at)gmail(dot)com>
Cc: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Identify root-cause for intermittent spikes
Date: 2022-10-13 08:33:28
Message-ID: Y0fNWMPTIbrC+Mwy@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Oct 12, 2022 at 10:46:23PM +0530, Sengottaiyan T wrote:
> Thanks, Michael.
>
> Due to reactive nature of the intermittent alerts, Is there any table which
> stores the historical information / periodic snapshots captured from the
> pg_stat_activity view?

No. Unless you will make one, and add data to it from some cron-like
thing.

Best regards,

depesz

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sengottaiyan T 2022-10-14 17:27:00 Re: Identify root-cause for intermittent spikes
Previous Message Sengottaiyan T 2022-10-12 17:19:19 Re: Identify root-cause for intermittent spikes