Re: Identify root-cause for intermittent spikes

Thanks, Depsez.

Please suggest: Is there any open-source tool available for capturing such
information?

On Thu, Oct 13, 2022, 14:03 hubert depesz lubaczewski <depesz@depesz.com>
wrote:

> 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
>
>