Open topic with navigation
Information about each snapshot in a snapshot storage manager's snapshot archive. For more information, see About Snapshot Storage Managers.
|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.|
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.