Skip to main content
Version: 6.2

Database Observability: Locks and Transactions

The Database Observability: Locks and Transactions dashboard helps identify blocking sessions, assess wait chains, and detect transactions that hold back the visibility horizon.

Who it is for: database administrators, on-call engineers, and application developers.

Data sources: db_activity*, db_metrics*, db_logs*.

Main Sections​

1. Lock Summary​

Shows the current level of contention:

  • number of waits and blocking sessions
  • longest wait and longest-running transaction
  • number of deadlocks
  • wait duration and held locks by type

Lock summary

2. Lock Waits​

Connects waiting and blocking sessions and shows the lock mode, duration, and participants.

Lock waits

3. Open Transactions​

Shows long-running and unfinished transactions, their state, application, and role.

Open transactions

4. Lock Holders and Modes​

Shows holders with the highest cumulative wait time and the distribution of held locks by mode.

Lock holders and modes

5. Deadlocks​

Shows deadlock events from the PostgreSQL log and the context in which they occurred.

Deadlocks in the log