bench_churn.sql

application/sql

Filename: bench_churn.sql

Type: application/sql

Part: 2

Message: Re: Improve pg_stat_statements scalability

\set roll random(1, 100)
\set hot random(1, 1000)
\set churn random(1, 100000)
\if :roll <= 80
WITH hot:hot AS (SELECT 1) SELECT FROM hot:hot
\else
WITH t:churn AS (SELECT 1) SELECT FROM t:churn
\endif