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

> System table containing logging entries with information about `BACKUP` and `RESTORE` operations.

# system.backups

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

Contains a list of all `BACKUP` or `RESTORE` operations with their current states and other properties. Note, that table is not persistent and it shows only operations executed after the last server restart.

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

* `id` ([String](/reference/data-types)) — Operation ID, can be either passed via SETTINGS id=... or be randomly generated UUID.
* `name` ([String](/reference/data-types)) — Operation name, a string like `Disk('backups', 'my_backup')`
* `base_backup_name` ([String](/reference/data-types)) — Base Backup Operation name, a string like `Disk('backups', 'my_base_backup')`
* `query_id` ([String](/reference/data-types)) — Query ID of a query that started backup.
* `status` ([Enum8('CREATING\_BACKUP' = 0, 'BACKUP\_CREATED' = 1, 'BACKUP\_FAILED' = 2, 'RESTORING' = 3, 'RESTORED' = 4, 'RESTORE\_FAILED' = 5, 'BACKUP\_CANCELLED' = 6, 'RESTORE\_CANCELLED' = 7)](/reference/data-types)) — Status of backup or restore operation.
* `error` ([String](/reference/data-types)) — The error message if any.
* `start_time` ([DateTime64(6)](/reference/data-types)) — The time when operation started.
* `end_time` ([DateTime64(6)](/reference/data-types)) — The time when operation finished.
* `num_files` ([UInt64](/reference/data-types)) — The number of files stored in the backup.
* `total_size` ([UInt64](/reference/data-types)) — The total size of files stored in the backup.
* `num_entries` ([UInt64](/reference/data-types)) — The number of entries in the backup, i.e. the number of files inside the folder if the backup is stored as a folder.
* `uncompressed_size` ([UInt64](/reference/data-types)) — The uncompressed size of the backup.
* `compressed_size` ([UInt64](/reference/data-types)) — The compressed size of the backup.
* `files_read` ([UInt64](/reference/data-types)) — Returns the number of files read during RESTORE from this backup.
* `bytes_read` ([UInt64](/reference/data-types)) — Returns the total size of files read during RESTORE from this backup.
* `ProfileEvents` ([Map(LowCardinality(String), UInt64)](/reference/data-types)) — All the profile events captured during this operation.