pg_stat_statements.sample_rate = 1.0 pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 314978.6 tps, lat 0.146 ms stddev 0.257, 0 failed progress: 20.0 s, 849655.3 tps, lat 0.054 ms stddev 0.108, 0 failed progress: 30.0 s, 1338227.1 tps, lat 0.034 ms stddev 0.045, 0 failed progress: 40.0 s, 1375800.0 tps, lat 0.033 ms stddev 0.042, 0 failed progress: 50.0 s, 1383403.2 tps, lat 0.033 ms stddev 0.039, 0 failed progress: 60.0 s, 1381348.2 tps, lat 0.033 ms stddev 0.044, 0 failed progress: 70.0 s, 1386079.3 tps, lat 0.033 ms stddev 0.040, 0 failed progress: 80.0 s, 1372314.9 tps, lat 0.033 ms stddev 0.040, 0 failed progress: 90.0 s, 1383231.2 tps, lat 0.033 ms stddev 0.042, 0 failed progress: 100.0 s, 1376702.3 tps, lat 0.033 ms stddev 0.042, 0 failed progress: 110.0 s, 1375622.4 tps, lat 0.033 ms stddev 0.043, 0 failed progress: 120.0 s, 1387577.0 tps, lat 0.033 ms stddev 0.040, 0 failed progress: 130.0 s, 1383540.3 tps, lat 0.033 ms stddev 0.039, 0 failed progress: 140.0 s, 1383138.6 tps, lat 0.033 ms stddev 0.040, 0 failed progress: 150.0 s, 1377247.6 tps, lat 0.033 ms stddev 0.042, 0 failed progress: 160.0 s, 1382830.9 tps, lat 0.033 ms stddev 0.039, 0 failed progress: 170.0 s, 1383637.7 tps, lat 0.033 ms stddev 0.041, 0 failed progress: 180.0 s, 1381811.7 tps, lat 0.033 ms stddev 0.041, 0 failed progress: 190.0 s, 1382384.7 tps, lat 0.033 ms stddev 0.041, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 259781895 number of failed transactions: 0 (0.000%) latency average = 0.035 ms latency stddev = 0.055 ms initial connection time = 26.448 ms tps = 1299070.105018 (without initial connection time) pgbench=# select query, calls from pg_stat_statements where calls > 1000; query | calls ------------------------------------------------------+----------- SELECT abalance FROM pgbench_accounts WHERE aid = $1 | 259781895 (1 row) pgbench=# show pg_stat_statements.sample_rate ; pg_stat_statements.sample_rate -------------------------------- 1 (1 row) pgbench=# select count(*) from pg_stat_statements; count ------- 130 (1 row) ======================================================================== pg_stat_statements.sample_rate = 0.8 pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 319046.3 tps, lat 0.144 ms stddev 0.257, 0 failed progress: 20.0 s, 893116.1 tps, lat 0.051 ms stddev 0.102, 0 failed progress: 30.0 s, 1440539.1 tps, lat 0.032 ms stddev 0.025, 0 failed progress: 40.0 s, 1484261.8 tps, lat 0.031 ms stddev 0.015, 0 failed progress: 50.0 s, 1483957.5 tps, lat 0.031 ms stddev 0.018, 0 failed progress: 60.0 s, 1491030.9 tps, lat 0.031 ms stddev 0.014, 0 failed progress: 70.0 s, 1483171.0 tps, lat 0.031 ms stddev 0.014, 0 failed progress: 80.0 s, 1475368.5 tps, lat 0.031 ms stddev 0.015, 0 failed progress: 90.0 s, 1487719.7 tps, lat 0.031 ms stddev 0.015, 0 failed progress: 100.0 s, 1485387.0 tps, lat 0.031 ms stddev 0.016, 0 failed progress: 110.0 s, 1474178.4 tps, lat 0.031 ms stddev 0.020, 0 failed progress: 120.0 s, 1489178.2 tps, lat 0.031 ms stddev 0.016, 0 failed progress: 130.0 s, 1480493.7 tps, lat 0.031 ms stddev 0.015, 0 failed progress: 140.0 s, 1477666.3 tps, lat 0.031 ms stddev 0.014, 0 failed progress: 150.0 s, 1483067.4 tps, lat 0.031 ms stddev 0.016, 0 failed progress: 160.0 s, 1480664.3 tps, lat 0.031 ms stddev 0.014, 0 failed progress: 170.0 s, 1482848.3 tps, lat 0.031 ms stddev 0.019, 0 failed progress: 180.0 s, 1482780.2 tps, lat 0.031 ms stddev 0.015, 0 failed progress: 190.0 s, 1487093.0 tps, lat 0.031 ms stddev 0.015, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 278630669 number of failed transactions: 0 (0.000%) latency average = 0.033 ms latency stddev = 0.039 ms initial connection time = 26.004 ms tps = 1393327.873249 (without initial connection time) pgbench=# select query, calls from pg_stat_statements where calls > 1000; query | calls ------------------------------------------------------+----------- SELECT abalance FROM pgbench_accounts WHERE aid = $1 | 222902226 (1 row) pgbench=# show pg_stat_statements.sample_rate ; pg_stat_statements.sample_rate -------------------------------- 0.8 (1 row) pgbench=# select count(*) from pg_stat_statements; count ------- 117 (1 row) ======================================================================== pg_stat_statements.sample_rate = 0.5 pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 313361.7 tps, lat 0.146 ms stddev 0.263, 0 failed progress: 20.0 s, 907177.0 tps, lat 0.051 ms stddev 0.103, 0 failed progress: 30.0 s, 1467741.3 tps, lat 0.031 ms stddev 0.022, 0 failed progress: 40.0 s, 1514111.4 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 50.0 s, 1508402.2 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 60.0 s, 1511752.6 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 70.0 s, 1505456.0 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 80.0 s, 1502666.4 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 90.0 s, 1512033.1 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 100.0 s, 1503996.7 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 110.0 s, 1506571.7 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 120.0 s, 1523809.6 tps, lat 0.030 ms stddev 0.013, 0 failed progress: 130.0 s, 1515853.1 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 140.0 s, 1511753.9 tps, lat 0.030 ms stddev 0.010, 0 failed progress: 150.0 s, 1511626.1 tps, lat 0.030 ms stddev 0.010, 0 failed progress: 160.0 s, 1513088.5 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 170.0 s, 1520756.9 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 180.0 s, 1519851.7 tps, lat 0.030 ms stddev 0.010, 0 failed progress: 190.0 s, 1517730.6 tps, lat 0.030 ms stddev 0.009, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 284023396 number of failed transactions: 0 (0.000%) latency average = 0.032 ms latency stddev = 0.037 ms initial connection time = 27.242 ms tps = 1420303.856480 (without initial connection time) pgbench=# select query, calls from pg_stat_statements where calls > 1000; query | calls ------------------------------------------------------+----------- SELECT abalance FROM pgbench_accounts WHERE aid = $1 | 142014320 (1 row) pgbench=# show pg_stat_statements.sample_rate ; pg_stat_statements.sample_rate -------------------------------- 0.5 (1 row) pgbench=# select count(*) from pg_stat_statements; count ------- 83 (1 row) ======================================================================== pg_stat_statements.sample_rate = 0.2 pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 305735.8 tps, lat 0.150 ms stddev 0.266, 0 failed progress: 20.0 s, 886211.5 tps, lat 0.052 ms stddev 0.105, 0 failed progress: 30.0 s, 1477449.3 tps, lat 0.031 ms stddev 0.023, 0 failed progress: 40.0 s, 1533608.6 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 50.0 s, 1520686.0 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 60.0 s, 1521163.7 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 70.0 s, 1506093.3 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 80.0 s, 1521926.6 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 90.0 s, 1532715.4 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 100.0 s, 1536818.2 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 110.0 s, 1532156.5 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 120.0 s, 1531077.6 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 130.0 s, 1533445.0 tps, lat 0.030 ms stddev 0.011, 0 failed progress: 140.0 s, 1530465.1 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 150.0 s, 1533264.8 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 160.0 s, 1531706.4 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 170.0 s, 1527768.1 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 180.0 s, 1523762.9 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 190.0 s, 1531264.7 tps, lat 0.030 ms stddev 0.008, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 286461834 number of failed transactions: 0 (0.000%) latency average = 0.032 ms latency stddev = 0.037 ms initial connection time = 26.189 ms tps = 1432482.672301 (without initial connection time) pgbench=# select query, calls from pg_stat_statements where calls > 1000; query | calls ------------------------------------------------------+---------- SELECT abalance FROM pgbench_accounts WHERE aid = $1 | 57294631 (1 row) pgbench=# show pg_stat_statements.sample_rate ; pg_stat_statements.sample_rate -------------------------------- 0.2 (1 row) pgbench=# select count(*) from pg_stat_statements; count ------- 56 (1 row) ======================================================================== pg_stat_statements.sample_rate = 0.0 pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 308612.3 tps, lat 0.149 ms stddev 0.263, 0 failed progress: 20.0 s, 904494.3 tps, lat 0.051 ms stddev 0.103, 0 failed progress: 30.0 s, 1497609.8 tps, lat 0.031 ms stddev 0.023, 0 failed progress: 40.0 s, 1549945.7 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 50.0 s, 1552001.6 tps, lat 0.030 ms stddev 0.009, 0 failed progress: 60.0 s, 1550998.6 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 70.0 s, 1552726.1 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 80.0 s, 1551847.2 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 90.0 s, 1542375.5 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 100.0 s, 1552666.8 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 110.0 s, 1542779.7 tps, lat 0.030 ms stddev 0.010, 0 failed progress: 120.0 s, 1533717.7 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 130.0 s, 1532413.9 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 140.0 s, 1544919.6 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 150.0 s, 1539568.5 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 160.0 s, 1551072.9 tps, lat 0.030 ms stddev 0.007, 0 failed progress: 170.0 s, 1558352.5 tps, lat 0.029 ms stddev 0.009, 0 failed progress: 180.0 s, 1556477.4 tps, lat 0.029 ms stddev 0.007, 0 failed progress: 190.0 s, 1549669.6 tps, lat 0.030 ms stddev 0.007, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 290169584 number of failed transactions: 0 (0.000%) latency average = 0.032 ms latency stddev = 0.036 ms initial connection time = 27.090 ms tps = 1451036.547496 (without initial connection time) pgbench=# select query, calls from pg_stat_statements where calls > 1000; query | calls -------+------- (0 rows) pgbench=# show pg_stat_statements.sample_rate ; pg_stat_statements.sample_rate -------------------------------- 0 (1 row) pgbench=# select count(*) from pg_stat_statements; count ------- 0 (1 row) ======================================================================== pg_stat_statements is off pgbench -c 46 -j 46 -T 200 -M prepared -S --progress=10 pgbench pgbench (16.6) starting vacuum...end. progress: 10.0 s, 316410.4 tps, lat 0.145 ms stddev 0.257, 0 failed progress: 20.0 s, 919027.2 tps, lat 0.050 ms stddev 0.103, 0 failed progress: 30.0 s, 1513827.2 tps, lat 0.030 ms stddev 0.021, 0 failed progress: 40.0 s, 1555707.4 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 50.0 s, 1552820.8 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 60.0 s, 1564985.9 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 70.0 s, 1559507.4 tps, lat 0.029 ms stddev 0.007, 0 failed progress: 80.0 s, 1561871.2 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 90.0 s, 1563076.5 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 100.0 s, 1562030.4 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 110.0 s, 1555040.3 tps, lat 0.029 ms stddev 0.008, 0 failed progress: 120.0 s, 1557295.8 tps, lat 0.029 ms stddev 0.008, 0 failed progress: 130.0 s, 1552556.9 tps, lat 0.029 ms stddev 0.008, 0 failed progress: 140.0 s, 1547155.3 tps, lat 0.030 ms stddev 0.006, 0 failed progress: 150.0 s, 1543266.5 tps, lat 0.030 ms stddev 0.008, 0 failed progress: 160.0 s, 1561086.8 tps, lat 0.029 ms stddev 0.007, 0 failed progress: 170.0 s, 1558993.9 tps, lat 0.029 ms stddev 0.009, 0 failed progress: 180.0 s, 1554616.8 tps, lat 0.029 ms stddev 0.006, 0 failed progress: 190.0 s, 1557972.0 tps, lat 0.029 ms stddev 0.007, 0 failed transaction type: scaling factor: 3000 query mode: prepared number of clients: 46 number of threads: 46 maximum number of tries: 1 duration: 200 s number of transactions actually processed: 292144256 number of failed transactions: 0 (0.000%) latency average = 0.031 ms latency stddev = 0.036 ms initial connection time = 29.085 ms tps = 1460920.805259 (without initial connection time)