v.22.8Improvement

Rework and Simplify system.backups Table Structure

Official CH changelog text
Rework and simplify the system.backups table, remove the internal column, allow user to set the ID of operation, add columns num_files, uncompressed_size, compressed_size, start_time, end_time. #39503 (Vitaly Baranov).
Rework and simplify the system.backups table by removing the internal column, adding new columns such as num_files, uncompressed_size, compressed_size, start_time, and end_time, and allowing users to set the ID of the backup operation.

Why it matters

This feature improves the system.backups table by making it more informative and user-friendly. Removing the internal column reduces clutter, while the new columns provide detailed insights into backup size, file counts, and timing. Allowing users to set the operation ID enables better tracking and management of backup processes.

How to use it

Users can now specify the ID of the backup operation during backup creation. The updated system.backups table automatically includes the new columns (num_files, uncompressed_size, compressed_size, start_time, and end_time) which can be queried directly to monitor backup details.

Related resources

PreviousNext