Postgresql 中文操作指南

28.3. Viewing Locks #

监视数据库活动的另一个有用工具是 pg_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:

pg_locks 视图的详细信息出现在 Section 54.12 中。有关使用 PostgreSQL 加锁和管理并发性的更多信息，请参阅 Chapter 13。

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.