28.1. Retrieving a Snapshot #

Execute the following query:

SELECT *
FROM pga_snapshot
WHERE snapshot_id = snapshot_ID;

Where snapshot_ID is the ID of the snapshot from the pga_snapshot metadata table.

To retrieve the latest snapshot, execute the following query:

SELECT *
FROM pga_snapshot
WHERE snapshot_id =
  (SELECT max(snapshot_id) FROM pga_snapshot);