##################################
## pg_stat_statements.max = 15000
##################################

## with patch


pgbench -c 20 -T 360 -n -f /tmp/wl.sql

transaction type: /tmp/wl.sql
scaling factor: 1
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 360 s
number of transactions actually processed: 732604
number of failed transactions: 0 (0.000%)
latency average = 9.828 ms
initial connection time = 33.349 ms
tps = 2035.051541 (without initial connection time)
[ec2-user@ip- pg_stat_statements]$
(1 row)



[ec2-user@ip- postgresql]$ cat /home/ec2-user/pg1/pgdata/logfile  | grep "pgss gc of queries file shrunk size" | wc -l
42

postgres=# select dealloc from pg_stat_statements_info;
 dealloc
---------
    3473
(1 row)



## no patch

transaction type: /tmp/wl.sql
scaling factor: 1
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 360 s
number of transactions actually processed: 683434
number of failed transactions: 0 (0.000%)
latency average = 10.535 ms
initial connection time = 32.788 ms
tps = 1898.452025 (without initial connection time)


[ec2-user@ip- postgresql]$ cat /home/ec2-user/pg1/pgdata/logfile  | grep "pgss gc of queries file shrunk size" | wc -l
154

postgres=# select dealloc from pg_stat_statements_info;
 dealloc
---------
    3239
(1 row)



##################################
## pg_stat_statements.max = 5000
##################################


## with patch


transaction type: /tmp/wl.sql
scaling factor: 1
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 360 s
number of transactions actually processed: 673135
number of failed transactions: 0 (0.000%)
latency average = 10.696 ms
initial connection time = 32.908 ms
tps = 1869.829843 (without initial connection time)


[ec2-user@ip- postgresql]$ cat /home/ec2-user/pg1/pgdata/logfile  | grep "pgss gc of queries file shrunk size" | wc -l
400
[ec2-user@ip- postgresql]$
[ec2-user@ip- postgresql]$
[ec2-user@ip- postgresql]$ psql
psql (15beta1)
Type "help" for help.

postgres=# select dealloc from pg_stat_statements_info;
 dealloc
---------
   12501
(1 row)



## no patch

transaction type: /tmp/wl.sql
scaling factor: 1
query mode: simple
number of clients: 20
number of threads: 1
maximum number of tries: 1
duration: 360 s
number of transactions actually processed: 656160
number of failed transactions: 0 (0.000%)
latency average = 10.973 ms
initial connection time = 33.275 ms
tps = 1822.678069 (without initial connection time)


[ec2-user@ip- postgresql]$ cat /home/ec2-user/pg1/pgdata/logfile  | grep "pgss gc of queries file shrunk size" | wc -l
580

[ec2-user@ip- postgresql]$ psql
psql (15beta1)
Type "help" for help.

postgres=# select dealloc from pg_stat_statements_info;
 dealloc
---------
   12180
(1 row)