Re: Finding detailed information about LOCKS

Can we not use pgbadger?

On Fri, 3 May, 2024, 11:46 am Laurenz Albe, <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Fri, 2024-05-03 at 10:54 +0530, Siraj G wrote:
> > I come from Oracle background. In Oracle there is a licensed feature
> (Diagnostics + Tuning)
> > upon using which the system keeps historic session records, which gives
> a better way
> > to find out locking related details- like the blocking session, total
> sessions blocked
> > and the time the blocking event was active. I am finding it a little
> hard in PgSQL
> > to find this information.
> >
> > I am seeking help in finding a detailed analysis on the locks that
> happened yesterday,
> > 2 days back or in the last week. Can someone assist please.
>
> PostgreSQL doesn't keep historical information on these things.
>
> You need a monitoring tool like pgwatch2 that takes regular snapshots of
> these data
> and allows you to access this information.
>
> Yours,
> Laurenz Albe
>
>
>