DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

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