Re: Identify root-cause for intermittent spikes - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: Identify root-cause for intermittent spikes
Date
Msg-id Y0fNWMPTIbrC+Mwy@depesz.com
Whole thread Raw
In response to Re: Identify root-cause for intermittent spikes  (Sengottaiyan T <techsenko@gmail.com>)
Responses Re: Identify root-cause for intermittent spikes
List 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




pgsql-performance by date:

Previous
From: Sengottaiyan T
Date:
Subject: Re: Identify root-cause for intermittent spikes
Next
From: Sengottaiyan T
Date:
Subject: Re: Identify root-cause for intermittent spikes