> ## 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 snapshot tracked by the Keeper state machine.

# system.keeper_snapshots

<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 snapshot file tracked by the in-process Keeper state machine, including snapshots currently being received from the leader.

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

* `last_log_index` ([UInt64](/reference/data-types/int-uint)) — Last log index covered by the snapshot.
* `path` ([String](/reference/data-types/string)) — Snapshot file path on the disk.
* `disk_name` ([String](/reference/data-types/string)) — Name of the disk that stores the snapshot.
* `size_bytes` ([UInt64](/reference/data-types/int-uint)) — Size of the snapshot file on disk.
* `last_modified_at` ([DateTime](/reference/data-types/datetime)) — Last modification time of the snapshot file.
* `is_received` ([Bool](/reference/data-types/boolean)) — `true` if the snapshot is currently being received from the leader. For such rows `size_bytes` and `last_modified_at` reflect the partial file as written so far and may underreport.
* `exists_on_disk` ([Bool](/reference/data-types/boolean)) — Whether the snapshot file is currently present on disk. Always `true` for finalized snapshots (`is_received` = `false`) unless the file was removed out of band or is corrupted; may be `false` for snapshots being received (`is_received` = `true`) before any bytes are written.

Example:

```sql theme={null}
SELECT * FROM system.keeper_snapshots ORDER BY last_log_index;
```

```text theme={null}
┌─last_log_index─┬─path──────────────────────────┬─disk_name─┬─size_bytes─┬────last_modified_at─┬─is_received─┬─exists_on_disk─┐
│           1000 │ snapshot_1000.bin.zstd        │ default   │      32468 │ 2026-05-22 14:00:00 │ false       │ true           │
│           2000 │ snapshot_2000.bin.zstd        │ default   │      48217 │ 2026-05-22 14:15:00 │ false       │ true           │
└────────────────┴───────────────────────────────┴───────────┴────────────┴─────────────────────┴─────────────┴────────────────┘
```