Pending transactions

Pending Transactions shows all currently open transactions in the active DBeaver session. It helps you identify uncommitted changes that may lock database objects or block other sessions. Use this window to review active transactions and commit or roll them back.

View pending transactions

To see pending transactions:

1. While working in the SQL Editor or Data Editor, click the arrow next to the Transaction Log button () in the toolbar and choose Pending transactions.

   

2. The Pending window consists of the Connections list and Transactions list tables.

   

   Info

   The Transactions list uses color indicators:

   • no color - in progress or pending
   • green - committed:
   • soft yellow - rolled back:
   • red - execution failed:

Connections list

The Connections list shows active connections and their transaction counters.

The counter is shown as pending / total and includes all queries executed inside the open transaction, both user queries and internal queries executed by DBeaver.

Tip

The counter may increase even if you run a single UPDATE. Internal SELECT queries are counted while the transaction is open.

When the window opens, only connections with pending transactions are shown. If there are none, the table is empty.

To display all active connections, select Show all connections.

Transactions list

The Transactions list shows queries for the selected connection.

• to see all previous transactions during the current session, select the Show previous transactions checkbox
• to see all queries including non-transactional ones, select the Show all queries checkbox

Commit or roll back transactions

You can commit or roll back transactions directly from this window:

1. Select the connection with uncommitted transactions
2. Click Commit () or Rollback (), depending on your goal.

If the operation succeeds, both buttons are disabled. If it fails, the system shows an error message.