system.backups

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

Description

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.

Columns

• id (String) — Operation ID, can be either passed via SETTINGS id=… or be randomly generated UUID.
• name (String) — Operation name, a string like Disk('backups', 'my_backup')
• base_backup_name (String) — Base Backup Operation name, a string like Disk('backups', 'my_base_backup')
• query_id (String) — 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)) — Status of backup or restore operation.
• error (String) — The error message if any.
• start_time (DateTime64(6)) — The time when operation started.
• end_time (DateTime64(6)) — The time when operation finished.
• num_files (UInt64) — The number of files stored in the backup.
• total_size (UInt64) — The total size of files stored in the backup.
• num_entries (UInt64) — 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) — The uncompressed size of the backup.
• compressed_size (UInt64) — The compressed size of the backup.
• files_read (UInt64) — Returns the number of files read during RESTORE from this backup.
• bytes_read (UInt64) — Returns the total size of files read during RESTORE from this backup.
• ProfileEvents (Map(LowCardinality(String), UInt64)) — All the profile events captured during this operation.