SHOW BACKUP

The SHOW BACKUP statement lists the contents of an enterprise backup created with the BACKUP statement.

Required privileges

Only members of the admin role can run SHOW BACKUP. By default, the root user belongs to the admin role.

Synopsis

SHOWBACKUPlocation

Parameters

ParameterDescription
locationThe location of the backup to inspect. For more details, see Backup File URLs.

Response

The following fields are returned.

FieldDescription
database_nameThe database name.
table_nameThe table name.
start_timeThe time at which the backup was started. For a full backup, this will be empty.
end_timeThe time at which the backup was completed.
size_bytesThe size of the backup, in bytes.

Example

  1. > SHOW BACKUP 'azure://acme-co-backup/tpch-2017-03-27-full?AZURE_ACCOUNT_KEY=hash&AZURE_ACCOUNT_NAME=acme-co';
  1. +---------------+---------------+------------+----------------------------------+------------+
  2. | database_name |  table_name   | start_time |             end_time             | size_bytes |
  3. +---------------+---------------+------------+----------------------------------+------------+
  4. | tpch          | nation        |            | 2017-03-27 13:54:31.371103+00:00 |       3828 |
  5. | tpch          | region        |            | 2017-03-27 13:54:31.371103+00:00 |       6626 |
  6. | tpch          | part          |            | 2017-03-27 13:54:31.371103+00:00 |       8128 |
  7. | tpch          | supplier      |            | 2017-03-27 13:54:31.371103+00:00 |       2834 |
  8. | tpch          | partsupp      |            | 2017-03-27 13:54:31.371103+00:00 |       3884 |
  9. | tpch          | customer      |            | 2017-03-27 13:54:31.371103+00:00 |      12736 |
  10. | tpch          | orders        |            | 2017-03-27 13:54:31.371103+00:00 |       6020 |
  11. | tpch          | lineitem      |            | 2017-03-27 13:54:31.371103+00:00 |     729811 |
  12. +---------------+---------------+------------+----------------------------------+------------+
  13. (8 rows)
  15. Time: 32.540353ms

See also

Was this page helpful?
YesNo