scaling factor: 3000 query mode: simple number of clients: 8 number of threads: 2 duration: 28800 s number of transactions actually processed: 71221374 latency average = 3.235 ms tps = 2472.964179 (including connections establishing) tps = 2472.964309 (excluding connections establishing) statement latencies in milliseconds: 0.001 \set aid1 random_gaussian(1, 100000 * :scale, 2.0) 0.001 \set aid2 random_gaussian(1, 100000 * :scale, 2.5) 0.000 \set delta random(-5000, 5000) 0.044 BEGIN; 0.280 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid1; 0.149 SELECT abalance FROM pgbench_accounts WHERE aid = :aid2; 2.758 END; scaling factor: 3000 query mode: simple number of clients: 8 number of threads: 2 duration: 28800 s number of transactions actually processed: 562888005 latency average = 0.409 ms tps = 19544.722130 (including connections establishing) tps = 19544.723213 (excluding connections establishing) statement latencies in milliseconds: 0.001 \set aid1 random_gaussian(1, 100000 * :scale, 2.0) 0.001 \set aid2 random_gaussian(1, 100000 * :scale, 2.5) 0.001 \set aid3 random_gaussian(1, 100000 * :scale, 3.2) 0.033 BEGIN; 0.115 SELECT abalance FROM pgbench_accounts WHERE aid = :aid1; 0.111 SELECT abalance FROM pgbench_accounts WHERE aid = :aid2; 0.109 SELECT abalance FROM pgbench_accounts WHERE aid = :aid3; 0.037 END; scaling factor: 3000 query mode: simple number of clients: 8 number of threads: 2 duration: 28800 s number of transactions actually processed: 29715 latency average = 7754.629 ms tps = 1.031642 (including connections establishing) tps = 1.031642 (excluding connections establishing) statement latencies in milliseconds: 7754.543 SELECT abalance FROM pgbench_accounts WHERE mtime > now() - INTERVAL '15min' ORDER BY aid;