Re: Finding detailed information about LOCKS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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.

Laurenz Albe

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux