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 | DESCRIBE } 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. You can also use the pipe operator to query the output of this command.

The output of the command includes the following columns, which describe the properties and metadata of the object:

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