SNAPSHOTS System Table Description

Description

Information about each snapshot in a snapshot storage manager's snapshot archive. For more information, see About Snapshot Storage Managers.

Fields

Field Type Description
SNAPSHOTID bigint The ID of the snapshot, which is the same as the ID of the transaction whose commit caused the snapshot to be saved.
TIME timestamp The approximate time (granularity of one second) that the snapshot storage manager received the message for the transaction commit associated with the snapshot.
ALBUM bigint The ID of the album that contains this snapshot.

Indexes

None

Example

SELECT * FROM system.snapshots;

SNAPSHOTID         TIME         ALBUM
----------- ------------------- ------
   1794     2015-04-29 14:31:34   1
    130     2015-04-29 14:31:35   2

Note: The table only shows snapshots in closed albums. So you need to wait 60 seconds ("--snapshot-min-time"). The system.snapshots table is updated every snapshot-min-time.You also can't restore from a snapshot until the album is closed.