Categories:

Account & Session DDL

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>

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 RESULT_SCAN function, which treats the output as a table that can be queried.

Output

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

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

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;
Back to top