Lock Manager

In DBeaver, you can use the Lock Manager to monitor and manage database locks. It helps identify blocking queries, and deadlocks, allowing you to resolve issues directly.

• AlloyDB
• Altibase
• Exasol
• Db2
• Greenplum
• Oracle

• PostgreSQL

To see the processes causing the blocks and their queries:

1. In the Database Navigator, expand your database connection.
2. Go to the Administer tab and select Lock Manager.
3. Review the list of active locks to identify blocking and waiting sessions.
4. Analyze the Wait Statement and Hold Statement columns to understand the conflicting queries.

Tip: Fields in the Lock Manager vary by database. Refer to your database's documentation for specifics.

To manage locks and resolve conflicts, use the options available bottom toolbar of the Lock Manager:

Button	Name	Description
	Kill waiting session	Terminates the session or process waiting for a lock, resolving blocking issues by stopping it.
	Configure auto-refresh	Sets up automatic refresh intervals to keep lock data updated without manual input.
	Refresh locks	Manually refreshes lock data to show the most recent information about active locks.

Tip: You can right-click on a specific lock in the list and use the context menu to perform the same actions.