{"Entry":{"collection":"catalog","key":"pg_stat_lock","name":"pg_stat_lock","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","order":false,"removed":[],"status":"added","to":"19","types":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of times a lock of this type could not be acquired via fast path because the fast path slot limit was exceeded. Increasing max_locks_per_transaction can reduce this number.","name":"fastpath_exceeded","to":"Number of times a lock of this type could not be acquired via fast path because the fast path slot limit was exceeded. Increasing max_locks_per_transaction can reduce this number. See Section 13.3.1.1 for which locks are eligible for fast-path locking; for ineligible lock types this counter is always zero."}],"from":"19","listing":[],"order":false,"removed":[],"status":"reworded","to":"20","types":[],"unlisted":[]}],"column_count":5,"content_hash":"225fc47ec1f586ec77ae36aab7b06d318b673b1274b3edcd39a92e8eb6d0b74c","first_version":"19","imported_at":"2026-09-30T00:40:55.926654+08:00","kind":"statistics","last_version":"20","name":"pg_stat_lock","position":93,"present_in":["19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:c757681c5bf19c3d12f7c5238ebc38fb4f4ffffb54258e9a2a8d36fb6c35e5df","summary":"The pg_stat_lock view will contain one row for each lock type, showing cluster-wide locks statistics.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_lock","SourceDatabase":"center","Version":"20","SourceTable":"catalog","SourceKey":"pg_stat_lock","SourceRevision":"english-manuals:c757681c5bf19c3d12f7c5238ebc38fb4f4ffffb54258e9a2a8d36fb6c35e5df","Facts":{"columns":[{"description":"Type of the lockable object. See pg_locks for details.","description_zh":"","documented":true,"documented_name":"locktype","hidden":false,"name":"locktype","references":"","type":"text"},{"description":"Number of times a lock of this type had to wait because of a conflicting lock. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout.","description_zh":"","documented":true,"documented_name":"waits","hidden":false,"name":"waits","references":"","type":"bigint"},{"description":"Total time spent waiting for locks of this type, in milliseconds. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout.","description_zh":"","documented":true,"documented_name":"wait_time","hidden":false,"name":"wait_time","references":"","type":"double precision"},{"description":"Number of times a lock of this type could not be acquired via fast path because the fast path slot limit was exceeded. Increasing max_locks_per_transaction can reduce this number. See Section 13.3.1.1 for which locks are eligible for fast-path locking; for ineligible lock types this counter is always zero.","description_zh":"","documented":true,"documented_name":"fastpath_exceeded","hidden":false,"name":"fastpath_exceeded","references":"","type":"bigint"},{"description":"Time at which these statistics were last reset.","description_zh":"","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","references":"","type":"timestamp with time zone"}],"description":"The pg_stat_lock view will contain one row for each lock type, showing cluster-wide locks statistics.","description_zh":"","doc":{"anchor":"PG-STAT-LOCK-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"},"kind":"statistics","lang":"en","measured_attributes":false,"metadata_release":"","runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-LOCK-VIEW","file":"monitoring-stats.html","lang":"en","sha256":"dfc27a108b70bdf88f310801ae3db011a8f608befd927722e5f3e9bdcc070251","slug":"devel"}},"MeasuredEvidence":{"measured_attributes":false,"metadata_release":"","runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_lock","SourceDatabase":"pgweb","Version":"20","Locale":"zh-Hans","Title":"pg_stat_lock","Summary":"pg_stat_lock视图将为每种锁类型包含一行，显示集簇范围的锁统计信息。","BodyHTML":"\u003cp\u003epg_stat_lock视图将为每种锁类型包含一行，显示集簇范围的锁统计信息。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"a97be96d20ebcc5e8fe5bb616d1b105971fe0e5e5a511e2670ad04510b2954cc","Payload":{"columns":[{"description_zh":"可加锁对象的类型。有关详细信息，请参阅pg_locks。","name":"locktype","type":"text","zh_from":"doc"},{"description_zh":"此类型的锁因与其他锁冲突而必须等待的次数。只有在等待超过deadlock_timeout后成功获得锁时才会递增。","name":"waits","type":"bigint","zh_from":"doc"},{"description_zh":"等待这种锁类型的总时间，以毫秒计。只有在等待超过deadlock_timeout后成功获得锁时才会递增。","name":"wait_time","type":"double precision","zh_from":"doc"},{"description_zh":"因超出快速路径槽数量上限而无法通过快速路径获取此类型锁的次数。增大max_locks_per_transaction可以减少此次数。哪些锁适用于快速路径加锁，见第 13.3.1.1 节；对于不适用的锁类型，此计数器始终为零。","name":"fastpath_exceeded","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间。","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"pg_stat_lock视图将为每种锁类型包含一行，显示集簇范围的锁统计信息。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}