3535' LANGUAGE 'plpgsql';
3636-- do something
3737SELECT count(*) FROM tenk2;
38- count
38+ count
3939-------
4040 10000
4141(1 row)
4242
4343SELECT count(*) FROM tenk2 WHERE unique1 = 1;
44- count
44+ count
4545-------
4646 1
4747(1 row)
4848
4949-- let stats collector catch up
5050SELECT sleep('0:0:2'::interval);
51- sleep
51+ sleep
5252-------
5353 0
5454(1 row)
@@ -60,7 +60,7 @@ SELECT st.seq_scan >= pr.seq_scan + 1,
6060 st.idx_tup_fetch >= pr.idx_tup_fetch + 1
6161 FROM pg_stat_user_tables AS st, pg_class AS cl, prevstats AS pr
6262 WHERE st.relname='tenk2' AND cl.relname='tenk2';
63- ?column? | ?column? | ?column? | ?column?
63+ ?column? | ?column? | ?column? | ?column?
6464----------+----------+----------+----------
6565 t | t | t | t
6666(1 row)
@@ -69,7 +69,7 @@ SELECT st.heap_blks_read + st.heap_blks_hit >= pr.heap_blks + cl.relpages,
6969 st.idx_blks_read + st.idx_blks_hit >= pr.idx_blks + 1
7070 FROM pg_statio_user_tables AS st, pg_class AS cl, prevstats AS pr
7171 WHERE st.relname='tenk2' AND cl.relname='tenk2';
72- ?column? | ?column?
72+ ?column? | ?column?
7373----------+----------
7474 t | t
7575(1 row)