On this page
Warning:
As of October 4, 2019, CockroachDB v2.0 is no longer supported. For more details, refer to the Release Support Policy.
New in v1.1: The SHOW BACKUP
statement lists the contents of an enterprise backup created with the BACKUP
statement.
Required Privileges
Only the root
user can run SHOW BACKUP
.
Synopsis
Parameters
Parameter | Description |
---|---|
location |
The location of the backup to inspect. For more details, see Backup File URLs. |
Response
The following fields are returned.
Field | Description |
---|---|
database |
The database name. |
table |
The table name. |
start_time |
The time at which the backup was started. For a full backup, this will be empty. |
end_time |
The time at which the backup was completed. |
size_bytes |
The size of the backup, in bytes. |
Example
> SHOW BACKUP 'azure://acme-co-backup/tpch-2017-03-27-full?AZURE_ACCOUNT_KEY=hash&AZURE_ACCOUNT_NAME=acme-co';
+----------+----------+------------+----------------------------------+------------+
| database | table | start_time | end_time | size_bytes |
+----------+----------+------------+----------------------------------+------------+
| tpch | nation | | 2017-03-27 13:54:31.371103+00:00 | 3828 |
| tpch | region | | 2017-03-27 13:54:31.371103+00:00 | 6626 |
| tpch | part | | 2017-03-27 13:54:31.371103+00:00 | 8128 |
| tpch | supplier | | 2017-03-27 13:54:31.371103+00:00 | 2834 |
| tpch | partsupp | | 2017-03-27 13:54:31.371103+00:00 | 3884 |
| tpch | customer | | 2017-03-27 13:54:31.371103+00:00 | 12736 |
| tpch | orders | | 2017-03-27 13:54:31.371103+00:00 | 6020 |
| tpch | lineitem | | 2017-03-27 13:54:31.371103+00:00 | 729811 |
+----------+----------+------------+----------------------------------+------------+
(8 rows)
Time: 32.540353ms