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

From Sengottaiyan T
Subject Re: Identify root-cause for intermittent spikes
Date
Msg-id CADjQTvL2w4-aV5iFiNgb5eCPrLVCWFzNmk-VoY6=QOjFW_aMEQ@mail.gmail.com
Whole thread Raw
In response to Re: Identify root-cause for intermittent spikes  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Identify root-cause for intermittent spikes
Re: Identify root-cause for intermittent spikes
List pgsql-performance
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

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Identify root-cause for intermittent spikes
Next
From: Julien Rouhaud
Date:
Subject: Re: Identify root-cause for intermittent spikes