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

SNAPSHOT.SNAPSHOT

SNAPSHOT records the index information, start time, and end time of WDR snapshots stored in the current system. The result can be queried only in the system database but cannot be queried in the user database. After the WDR snapshot function is enabled (the GUC parameter enable_wdr_snapshot is set to on), the table is created.

Table 1 SNAPSHOT attributes

Name

Type

Description

Example

snapshot_id

bigint

WDR snapshot ID

1

start_ts

timestamp

Start time of a WDR snapshot

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

end_ts

timestamp

End time of a WDR snapshot

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

version

int

Version of a WDR snapshot

1