> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

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

# system.transactions_info_log

<h2 id="description">
  Description
</h2>

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.

```xml theme={null}
<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.

<h2 id="columns">
  Columns
</h2>

* `hostname` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — The hostname where transaction was executed.
* `clickhouse_version` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — Version of the ClickHouse server that produced the row.
* `system_processor` ([LowCardinality(String)](/reference/data-types/lowcardinality)) — CPU architecture of the ClickHouse server that produced the row.
* `type` ([Enum8('Begin' = 1, 'Commit' = 2, 'Rollback' = 3, 'AddPart' = 10, 'LockPart' = 11, 'UnlockPart' = 12)](/reference/data-types/enum)) — The type of the transaction. Possible values: Begin, Commit, Rollback, AddPart, LockPart, UnlockPart.
* `event_date` ([Date](/reference/data-types/date)) — Date of the entry.
* `event_time` ([DateTime64(6)](/reference/data-types/datetime64)) — Time of the entry
* `thread_id` ([UInt64](/reference/data-types/int-uint)) — The identifier of a thread.
* `query_id` ([String](/reference/data-types/string)) — The ID of a query executed in a scope of transaction.
* `tid` ([Tuple(UInt64, UInt64, UUID, Int64)](/reference/data-types/tuple)) — The identifier of a transaction.
* `tid_hash` ([UInt64](/reference/data-types/int-uint)) — The hash of the identifier.
* `csn` ([UInt64](/reference/data-types/int-uint)) — The Commit Sequence Number
* `database` ([String](/reference/data-types/string)) — The name of the database the transaction was executed against.
* `table` ([String](/reference/data-types/string)) — The name of the table the transaction was executed against.
* `uuid` ([UUID](/reference/data-types/uuid)) — The uuid of the table the transaction was executed against.
* `part` ([String](/reference/data-types/string)) — The name of the part participated in the transaction.