pgbench -U pgbench -d pgbench -c 10 -j 10 -T 600 -P 60 -r -v
pgbench (17.5)
starting vacuum...end.
starting vacuum pgbench_accounts...end.
progress: 60.0 s, 2507.5 tps, lat 3.980 ms stddev 2.263, 0 failed
progress: 120.0 s, 2759.8 tps, lat 3.623 ms stddev 1.932, 0 failed
progress: 180.0 s, 2482.3 tps, lat 4.028 ms stddev 2.242, 0 failed
progress: 240.0 s, 2445.1 tps, lat 4.089 ms stddev 2.327, 0 failed
progress: 300.0 s, 2437.2 tps, lat 4.102 ms stddev 2.290, 0 failed
progress: 360.0 s, 2432.2 tps, lat 4.111 ms stddev 2.335, 0 failed
progress: 420.0 s, 2662.9 tps, lat 3.755 ms stddev 2.056, 0 failed
progress: 480.0 s, 2444.1 tps, lat 4.091 ms stddev 2.281, 0 failed
progress: 540.0 s, 2451.4 tps, lat 4.079 ms stddev 2.285, 0 failed
progress: 600.0 s, 2444.8 tps, lat 4.090 ms stddev 2.331, 0 failed
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 10
query mode: simple
number of clients: 10
number of threads: 10
maximum number of tries: 1
duration: 600 s
number of transactions actually processed: 1504052
number of failed transactions: 0 (0.000%)
latency average = 3.988 ms
latency stddev = 2.239 ms
initial connection time = 112.786 ms
tps = 2507.180732 (without initial connection time)
statement latencies in milliseconds and failures:
0.002 0 \set aid random(1, 100000 * :scale)
0.000 0 \set bid random(1, 1 * :scale)
0.000 0 \set tid random(1, 10 * :scale)
0.000 0 \set delta random(-5000, 5000)
0.081 0 BEGIN;
0.168 0 UPDATE pgbench_accounts SET abalance = abalance + :delta WHERE aid = :aid;
0.134 0 SELECT abalance FROM pgbench_accounts WHERE aid = :aid;
0.320 0 UPDATE pgbench_tellers SET tbalance = tbalance + :delta WHERE tid = :tid;
1.240 0 UPDATE pgbench_branches SET bbalance = bbalance + :delta WHERE bid = :bid;
0.115 0 INSERT INTO pgbench_history (tid, bid, aid, delta, mtime) VALUES (:tid, :bid, :aid, :delta, CURRENT_TIMESTAMP);
1.931 0 END;