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 <dep...@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 > >
