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

Parameters

transaction_id

Specifies the identifier of the transaction to describe.

transaction_id must be a literal, not a session variable.

Usage notes

  • To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

    For example, you can use the pipe operator or RESULT_SCAN function to select specific columns from the SHOW command output or filter the rows.

    When you refer to the output columns, use double-quoted identifiers for the column names. For example, to select the output column type, specify SELECT "type".

    You must use double-quoted identifiers because the output column names for SHOW commands are in lowercase. The double quotes ensure that the column names in the SELECT list or WHERE clause match the column names in the SHOW command output that was scanned.

Output

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.

Examples

DESC TRANSACTION 1651535571261000000;
Copy
Language: English