Re: Identify root-cause for intermittent spikes

From: Sengottaiyan T <techsenko(at)gmail(dot)com>
To: depesz(at)depesz(dot)com
Cc: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Identify root-cause for intermittent spikes
Date: 2022-10-14 17:27:00
Message-ID: CADjQTvL2w4-aV5iFiNgb5eCPrLVCWFzNmk-VoY6=QOjFW_aMEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)depesz(dot)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
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Julien Rouhaud 2022-10-15 10:35:22 Re: Identify root-cause for intermittent spikes
Previous Message hubert depesz lubaczewski 2022-10-13 08:33:28 Re: Identify root-cause for intermittent spikes