Re: Identify root-cause for intermittent spikes

Поиск
Список
Период
Сортировка
От Sengottaiyan T
Тема Re: Identify root-cause for intermittent spikes
Дата
Msg-id CADjQTvL2w4-aV5iFiNgb5eCPrLVCWFzNmk-VoY6=QOjFW_aMEQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Identify root-cause for intermittent spikes  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: Identify root-cause for intermittent spikes  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Identify root-cause for intermittent spikes  (Julien Rouhaud <rjuju123@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Identify root-cause for intermittent spikes
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Identify root-cause for intermittent spikes