SET enable_indexscan TO on;

-- for the moment, we don't want index-only scans here

SET enable_indexonlyscan TO off;

-- wait to let any prior tests finish dumping out stats;

-- else our messages might get lost due to contention

SELECT pg_sleep_for('2 seconds');

pg_sleep_for

--------------

(1 row)

-- save counters

CREATETEMPTABLE prevstats AS

CREATE TABLE prevstats AS

SELECT t.seq_scan, t.seq_tup_read, t.idx_scan, t.idx_tup_fetch,

(b.heap_blks_read + b.heap_blks_hit) AS heap_blks,

(b.idx_blks_read + b.idx_blks_hit) AS idx_blks,

exit when updated1 and updated2 and updated3;

-- wait a little

performpg_sleep(0.1);

performpg_sleep_for('100 milliseconds');

-- reset stats snapshot so we can test again

perform pg_stat_clear_snapshot();

1

(1 row)

-- force the rate-limiting logic in pgstat_report_stat() to time out

-- and send a message

SELECT pg_sleep(1.0);

pg_sleep

----------

(1 row)

-- We can't just call wait_for_stats() at this point, because we only

-- transmit stats when the session goes idle, and we probably didn't

-- transmit the last couple of counts yet thanks to the rate-limiting logic

-- in pgstat_report_stat(). But instead of waiting for the rate limiter's

-- timeout to elapse, let's just start a new session. The old one will

-- then send its stats before dying.

\c -

-- wait for stats collector to update

SELECT wait_for_stats();

wait_for_stats

(1 row)

DROP TABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_test4;

DROP TABLE prevstats;

-- End of Stats Test

SET enable_indexonlyscan TO off;

SELECT pg_sleep_for('2 seconds');

CREATETEMPTABLE prevstatsAS

SELECTt.seq_scan,t.seq_tup_read,t.idx_scan,t.idx_tup_fetch,

(b.heap_blks_read+b.heap_blks_hit)AS heap_blks,

(b.idx_blks_read+b.idx_blks_hit)AS idx_blks,

exit when updated1and updated2and updated3;

performpg_sleep(0.1);

performpg_sleep_for('100 milliseconds');

perform pg_stat_clear_snapshot();

SELECTcount(*)FROM tenk2WHERE unique1=1;

SELECT pg_sleep(1.0);

\c-

SELECT wait_for_stats();

FROM prevstatsAS pr;

DROPTABLE trunc_stats_test, trunc_stats_test1, trunc_stats_test2, trunc_stats_test3, trunc_stats_test4;

DROPTABLE prevstats;