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