Horton

Re: Identify root-cause for intermittent spikes

hubert depesz lubaczewski <depesz@depesz.com>

View thread View on postgr.es
From: hubert depesz lubaczewski <depesz@depesz.com>
To: Sengottaiyan T <techsenko@gmail.com>
Cc: MichaelDBA <MichaelDBA@sqlexec.com>, pgsql-performance@postgresql.org
Date: 2022-10-13T08:33:28Z
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