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.