blob: 2f4405c71577c6a8df5014eb85c8f2322bad96ad [file] [log] [blame]
CREATE TABLE t1 ( uid INTEGER PRIMARY KEY, uname TEXT NOT NULL );
CREATE TABLE
INSERT INTO t1 VALUES ( 101, 'Park Gyu-Ri' );
INSERT 0 1
INSERT INTO t1 VALUES ( 102, 'Han Seung-Yeon' );
INSERT 0 1
INSERT INTO t1 VALUES ( 103, 'Nicole' );
INSERT 0 1
INSERT INTO t1 VALUES ( 104, 'Koo Ha-Ra' );
INSERT 0 1
INSERT INTO t1 VALUES ( 105, 'Kang Ji-Young' );
INSERT 0 1
SELECT pgperf.create_snapshot_pgstattuple(0);
create_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
1
(1 row)
SELECT pgperf.create_snapshot_pgstattuple(1);
create_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
2
(1 row)
SELECT pgperf.create_snapshot_pgstattuple(2);
create_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
3
(1 row)
SELECT pgperf.delete_snapshot_pgstattuple(1);
delete_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
2
(1 row)
SELECT pgperf.delete_snapshot_pgstattuple(2);
delete_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
1
(1 row)
SELECT pgperf.delete_snapshot_pgstattuple(0);
delete_snapshot_pgstattuple
-----------------------------
t
(1 row)
SELECT count(*) FROM pgperf.snapshot_pgstattuple WHERE schemaname <> 'pgperf';
count
-------
0
(1 row)
DROP TABLE t1;
DROP TABLE