27.3. Viewing Locks

Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information about the outstanding locks in the lock manager. For example, this capability can be used to:

Details of the pg_locks view appear in Section 45.58. For more information on locking and managing concurrency with PostgreSQL, refer to Chapter 13.

copyright  ©  July 24 2014 sean dreilinger url: http://durak.org/sean/pubs/software/postgresql/monitoring-locks.html