DESCRIBE TRANSACTION¶

Describes the transaction, including the start time and the state (running, committed, rolled back).

DESCRIBE can be abbreviated to DESC.

See also:: CURRENT_TRANSACTION , LAST_TRANSACTION , BEGIN , COMMIT , ROLLBACK , SHOW TRANSACTIONS

Syntax¶

DESC[RIBE] TRANSACTION <transaction_id>

Copy

transaction_id

Specifies the identifier of the transaction to describe.

transaction_id must be a literal, not a session variable.

To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

The command output provides transaction properties and metadata in the following columns:

| id | user | session name | started on | state | ended_on |

Copy

Column	Description
`id`	Unique identifier of the transaction.
`user`	The user ID of the user who ran the transaction.
`session name`	The ID of the user session in which the transaction was executed.
`started_on`	Date and time that the transaction was created.
`state`	The transaction’s completion status, e.g. committed, rolled back, or still running.
`ended_on`	Date and time that the transaction finished.

DESC TRANSACTION 1651535571261000000;

Copy