src/pgperf/t/101_create_snapshot_pg_current_xlog/input/test.sql

SELECT * FROM pgperf.snapshot_pg_current_xlog ORDER BY 1;

SELECT pgperf.create_snapshot_pg_current_xlog(0);
SELECT pgperf.create_snapshot_pg_current_xlog(1);

WITH s0 AS (
SELECT * FROM pgperf.snapshot_pg_current_xlog WHERE sid = 0
), s1 AS (
SELECT * FROM pgperf.snapshot_pg_current_xlog WHERE sid = 1
)
SELECT s0.location < s1.location, s0.insert_location < s1.insert_location
  FROM s0, s1
 WHERE s0.sid + 1 = s1.sid;

SELECT count(*) FROM pgperf.snapshot_pg_current_xlog;

SELECT pgperf.delete_snapshot_pg_current_xlog(1);

SELECT count(*) FROM pgperf.snapshot_pg_current_xlog;

SELECT pgperf.delete_snapshot_pg_current_xlog(0);

SELECT count(*) FROM pgperf.snapshot_pg_current_xlog;