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

SNAPSHOT.SNAPSHOT

SNAPSHOT records the index information, start time, and end time of WDR snapshots stored in the current system. Only the initial user or monitor administrator has the permission to view the information. The result can be queried only in the system database but cannot be queried in the user database, 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 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

snap_flag

bigint

Attribute of the WDR snapshot.

  • NULL: The snapshot is of an earlier version.
  • 0: The snapshot is a full snapshot.
  • 1: The snapshot is an incremental snapshot.

0

base_snapshot_id

bigint

ID of the full snapshot corresponding to the WDR snapshot.

1