Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ Schemas/ WDR Snapshot Schema/ Original Information of WDR Snapshots/ SNAPSHOT.TABLES_SNAP_TIMESTAMP
Updated on 2024-05-07 GMT+08:00
View PDF
Share

SNAPSHOT.TABLES_SNAP_TIMESTAMP

TABLES_SNAP_TIMESTAMP records the databases, table objects, and start and end time of all WDR snapshots. 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