> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table which exists only when this node runs an in-process ClickHouse Keeper. Contains one row per on-disk Raft changelog file tracked by the Keeper log store.

# system.keeper_changelogs

<Info>
  **Querying in ClickHouse Cloud**

  The data in this system table is held locally on each node in ClickHouse Cloud. Obtaining a complete view of all data, therefore, requires the `clusterAllReplicas` function. See [here](/reference/system-tables/overview#system-tables-in-clickhouse-cloud) for further details.
</Info>

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

This table does not exist if this node is not configured to run an in-process ClickHouse Keeper. It contains one row per Raft changelog file (`changelog_<from>_<to>.bin[.zstd]`) tracked by the in-process Keeper log store, including the active file currently being appended to.

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

* `from_log_index` ([UInt64](/reference/data-types/int-uint)) — First Raft log index in the file (inclusive).
* `to_log_index` ([UInt64](/reference/data-types/int-uint)) — Last Raft log index covered by the filename (inclusive). For the active file this is the rotation target and may be ahead of `last_entry_index`.
* `last_entry_index` ([Nullable(UInt64)](/reference/data-types/int-uint)) — Highest log index actually appended to this file. `NULL` if the active file has not received any entries yet or the file is broken.
* `entries` ([UInt64](/reference/data-types/int-uint)) — Number of entries appended to this file. `ALIAS` for `ifNull(last_entry_index - from_log_index + 1, 0)`.
* `path` ([String](/reference/data-types/string)) — File path on the disk.
* `disk_name` ([String](/reference/data-types/string)) — Name of the disk holding the file.
* `size_bytes` ([UInt64](/reference/data-types/int-uint)) — Size of the file on disk.
* `modification_time` ([DateTime](/reference/data-types/datetime)) — Last modification time of the file.
* `is_compressed` ([Bool](/reference/data-types/boolean)) — File payload is zstd-compressed.
* `active` ([Bool](/reference/data-types/boolean)) — This file is currently being appended to.
* `is_broken` ([Bool](/reference/data-types/boolean)) — Trailing record was found corrupted at startup.

Example:

```sql theme={null}
SELECT from_log_index, to_log_index, entries, path, active FROM system.keeper_changelogs ORDER BY from_log_index;
```

```text theme={null}
┌─from_log_index─┬─to_log_index─┬─entries─┬─path───────────────────────────┬─active─┐
│              1 │         1000 │    1000 │ changelog_1_1000.bin.zstd      │ false  │
│           1001 │         2000 │     537 │ changelog_1001_2000.bin.zstd   │ true   │
└────────────────┴──────────────┴─────────┴────────────────────────────────┴────────┘
```