Help Center/ GaussDB/ Centralized_8.x/ Schemas/ WDR Snapshot Schema/ Original Information of WDR Snapshots/ SNAPSHOT.TABLES_SNAP_TIMESTAMP
Updated on 2024-06-03 GMT+08:00
View PDF

SNAPSHOT.TABLES_SNAP_TIMESTAMP

TABLES_SNAP_TIMESTAMP records the databases, table objects, and start and end time of all WDR snapshots, as described in Table 1. After the WDR snapshot function is enabled (the GUC parameter enable_wdr_snapshot is set to on), the table is created.

Table 1 TABLES_SNAP_TIMESTAMP attributes

Name

Type

Description

Example

snapshot_id

bigint

WDR snapshot ID.

1

node_name

name

Name of the node to which the table information of the WDR snapshot belongs.

dn_6001

db_name

text

Database corresponding to a WDR snapshot.

tpcc1000

tablename

text

Table corresponding to a WDR snapshot.

snap_xc_statio_all_indexes

start_ts

timestamp

Start time of a WDR snapshot.

2019-12-28 17:11:27.425849+08

end_ts

timestamp

End time of a WDR snapshot.

2019-12-28 17:11:27.707398+08