Skip to main content
Querying in ClickHouse CloudThe 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 for further details.

​
Description

Contains logging entries with information about BACKUP and RESTORE operations. It is safe to truncate or drop this table at any time.

​
Columns

  • hostname (LowCardinality(String)) — Hostname of the server executing the query.
  • 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.
  • event_date (Date) — Date of the entry.
  • event_time (DateTime) — Time of the entry.
  • event_time_microseconds (DateTime64(6)) — Time of the entry with microseconds precision.
  • id (String) — Identifier of the backup or restore operation.
  • name (String) — Name of the backup storage (the contents of the FROM or TO clause).
  • base_backup_name (String) — The name of base backup in case incremental one.
  • query_id (String) — The ID of a query associated with a backup operation.
  • status (Enum8(‘CREATING_BACKUP’ = 0, ‘BACKUP_CREATED’ = 1, ‘BACKUP_FAILED’ = 2, ‘RESTORING’ = 3, ‘RESTORED’ = 4, ‘RESTORE_FAILED’ = 5, ‘BACKUP_CANCELLED’ = 6, ‘RESTORE_CANCELLED’ = 7)) — Operation status.
  • error (String) — Error message of the failed operation (empty string for successful operations).
  • start_time (DateTime64(6)) — Start time of the operation.
  • end_time (DateTime64(6)) — End time of the operation.
  • num_files (UInt64) — Number of files stored in the backup.
  • total_size (UInt64) — Total size of files stored in the backup.
  • num_entries (UInt64) — Number of entries in the backup, i.e. the number of files inside the folder if the backup is stored as a folder, or the number of files inside the archive if the backup is stored as an archive. It is not the same as num_files if it’s an incremental backup or if it contains empty files or duplicates. The following is always true: num_entries ≤ num_files.
  • uncompressed_size (UInt64) — Uncompressed size of the backup.
  • compressed_size (UInt64) — Compressed size of the backup. If the backup is not stored as an archive it equals to uncompressed_size.
  • files_read (UInt64) — Number of files read during the restore operation.
  • bytes_read (UInt64) — Total size of files read during the restore operation.
  • settings (Map(LowCardinality(String), String)) — Backup/restore-specific settings effectively used for this operation (from the SETTINGS clause, including defaults). Sensitive settings are not exposed.
  • engine_settings (Map(LowCardinality(String), String)) — Settings effectively used by the backup engine’s reader/writer (e.g. S3 allow_native_copy). Empty when the operation involves more than one engine that a flat map cannot represent: incremental backups and restores, lightweight snapshot restores, and non-internal ON CLUSTER operations.

​
Example

This is essentially the same information that is written in the system table system.backups:

​
See Also

Last modified on September 11, 2026