system.transactions_info_log

Contains information about all transactions executed on a current server. It is safe to truncate or drop this table at any time.

Description

Contains information about all transactions executed on a current server.

Availability

system.transactions_info_log is created only when the server configuration contains a transactions_info_log section. Transactions must also be enabled with allow_experimental_transactions for the table to accumulate rows. Without the log section, queries against the table fail with UNKNOWN_TABLE; without experimental transactions, the configured table remains empty.

<clickhouse>
    <allow_experimental_transactions>1</allow_experimental_transactions>
    <transactions_info_log>
        <database>system</database>
        <table>transactions_info_log</table>
        <partition_by>toYYYYMM(event_date)</partition_by>
        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
    </transactions_info_log>
</clickhouse>

It is safe to truncate or drop this table at any time.

Columns

• hostname (LowCardinality(String)) — The hostname where transaction was executed.
• clickhouse_version (LowCardinality(String)) — Version of the ClickHouse server that produced the row.
• system_processor (LowCardinality(String)) — CPU architecture of the ClickHouse server that produced the row.
• type (Enum8(‘Begin’ = 1, ‘Commit’ = 2, ‘Rollback’ = 3, ‘AddPart’ = 10, ‘LockPart’ = 11, ‘UnlockPart’ = 12)) — The type of the transaction. Possible values: Begin, Commit, Rollback, AddPart, LockPart, UnlockPart.
• event_date (Date) — Date of the entry.
• event_time (DateTime64(6)) — Time of the entry
• thread_id (UInt64) — The identifier of a thread.
• query_id (String) — The ID of a query executed in a scope of transaction.
• tid (Tuple(UInt64, UInt64, UUID, Int64)) — The identifier of a transaction.
• tid_hash (UInt64) — The hash of the identifier.
• csn (UInt64) — The Commit Sequence Number
• database (String) — The name of the database the transaction was executed against.
• table (String) — The name of the table the transaction was executed against.
• uuid (UUID) — The uuid of the table the transaction was executed against.
• part (String) — The name of the part participated in the transaction.