25.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 43.39 . For more information on locking and managing concurrency with PostgreSQL , refer to Chapter 12 .