Hello Admins!
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.
Regards
Siraj