28.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 54.12. For more information on locking and managing concurrency with PostgreSQL, refer to Chapter 13.