Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

SVV_TRANSACTIONS

Records information about transactions that currently hold locks on tables in the database. Use the SVV_TRANSACTIONS view to identify open transactions and lock contention issues. For more information about locks, see Managing Concurrent Write Operations and LOCK.

All rows in SVV_TRANSACTIONS, including rows generated by another user, are visible to all users.

Table Columns

Column Name Data Type Description
txn_owner text Name of the owner of the transaction.
txn_db bigint Name of the database associated with the transaction.
xid bigint Transaction ID.
pid bigint Process ID associated with the lock.
txn_start timestamp Start time of the transaction.
lock_mode text Name of the lock mode held or requested by this process. If lock_mode is ExclusiveLock and granted is true (t), then this transaction ID is an open transaction.
lockable_object_type text Type of object requesting or holding the lock, either relation if it is a table or transactionid if it is a transaction.
relation oid Table ID for the table (relation) acquiring the lock. This value is NULL if lockable_object_type is transactionid.
granted text Value that indicates whether that the lock has been granted (t) or is pending (f) .

Sample Queries

The following command shows all active transactions and the locks requested by each transaction.

Copy
select * from svv_transactions; txn_ lockable_ owner | txn_db | xid | pid | txn_start | lock_mode | object_type | relation | granted -------+--------+--------+-------+----------------------------+---------------------+----------------+----------+--------- root | dev | 438484 | 22223 | 2016-03-02 18:42:18.862254 | AccessShareLock | relation | 100068 | t root | dev | 438484 | 22223 | 2016-03-02 18:42:18.862254 | ExclusiveLock | transactionid | | t root | tickit | 438490 | 22277 | 2016-03-02 18:42:48.084037 | AccessShareLock | relation | 50860 | t root | tickit | 438490 | 22277 | 2016-03-02 18:42:48.084037 | AccessShareLock | relation | 52310 | t root | tickit | 438490 | 22277 | 2016-03-02 18:42:48.084037 | ExclusiveLock | transactionid | | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | AccessExclusiveLock | relation | 100068 | f root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | RowExclusiveLock | relation | 16688 | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | AccessShareLock | relation | 100064 | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | AccessExclusiveLock | relation | 100166 | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | AccessExclusiveLock | relation | 100171 | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | AccessExclusiveLock | relation | 100190 | t root | dev | 438505 | 22378 | 2016-03-02 18:43:27.611292 | ExclusiveLock | transactionid | | t (12 rows) (12 rows)