Product DocumentationAppearance
sys.log_restore
This view records the history of restore (ybrestore) operations.
| Column Name | Data Type | Description |
|---|---|---|
| session_key | text | Unique session key generated for the restore operation. |
| session_id | bigint | Unique ID of the ybrestore session. |
| client_hostname | text | Client host name, if available. |
| client_username | text | Operating system user on the client system who is running the restore tool. |
| user_name | text | Name of the database user, as passed in on the ybrestore command line (or set with YBUSER). |
| user_id | bigint | Unique ID of the database user. |
| database_name | text | Name of the restored database. |
| database_id | bigint | Unique ID of the restored database. |
| state | text | Current state of the restore operation, such as USER_DATA_RUNNING or DONE. |
| error_string | text | Error message reported for a failed restore. For example, if a restore is cancelled before it completes, the view may report an External data socket error. |
| start_time | timestamptz | When the ybrestore command started running. |
| end_time | timestamptz | When the ybrestore command completed. |
| elapsed_ms | bigint | Time spent running the restore (in milliseconds). |
| remaining_ms | bigint | Time remaining to complete the restore (in milliseconds). |
| received_bytes | bigint | Number of bytes transferred over the network. |
| received_bytes_per_sec | double precision | Number of bytes per second transferred over the network. |
| storage_bytes | bigint | Number of bytes stored in the target location. |
| storage_bytes_per_sec | double precision | Number of bytes per second being stored in the target location. |
| backup_point_id | text | Backup name as specified with the ybbackup --name option. |
| chain_id | text | Name of the backup chain. |
| source_database_name | text | Name of the source database for the restore (not the restored database name in the case of a database being restored to an alias). |
| source_appliance_name | text | Name of the appliance where the database was backed up. |
Example
premdb=# select * from sys.log_restore;
-[ RECORD 1 ]----------+-----------------------------------------------------------------
session_key | BSz3VTMYTqbeX6AR-QspATzuMelRcjI_WlkdaIL9EOjpm49witdmc20HCncmI4It
session_id | 40984
client_hostname | localhost
client_username | yb100
user_name | yb100
user_id | 16417
database_name | premdb_restored
database_id | 16428
state | DONE
error_string | [NULL]
start_time | 2020-01-13 18:19:49.381-08
end_time | 2020-01-13 18:20:07.967-08
elapsed_ms | 18586
remaining_ms | 0
received_bytes | 8121140
received_bytes_per_sec | 436949.316689982
storage_bytes | 8111423
storage_bytes_per_sec | 436426.50382008
backup_point_id | Jan13Full
chain_id | January2020
source_database_name | premdb
source_appliance_name | localhostParent topic:System Views