Updated on 2024-05-07 GMT+08:00

SNAPSHOT.TABLES_SNAP_TIMESTAMP

TABLES_SNAP_TIMESTAMP records the start time and end time of data collection, as well as corresponding databases, and table objects for all stored WDR snapshots. Only the initialization user or monitor administrator has the permission to view the table. 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

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