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);