pgbench (19devel) progress: 1765546063.294 s, 65870.5 tps, lat 0.298 ms stddev 0.136, 0 failed progress: 1765546068.294 s, 62181.9 tps, lat 0.316 ms stddev 0.137, 0 failed progress: 1765546073.294 s, 61075.5 tps, lat 0.322 ms stddev 0.141, 0 failed progress: 1765546078.294 s, 60555.0 tps, lat 0.325 ms stddev 0.140, 0 failed progress: 1765546083.294 s, 59835.7 tps, lat 0.329 ms stddev 0.144, 0 failed progress: 1765546088.294 s, 59338.7 tps, lat 0.331 ms stddev 0.148, 0 failed progress: 1765546093.294 s, 58621.2 tps, lat 0.335 ms stddev 0.147, 0 failed progress: 1765546098.294 s, 58402.5 tps, lat 0.337 ms stddev 0.154, 0 failed progress: 1765546103.294 s, 58237.6 tps, lat 0.338 ms stddev 0.153, 0 failed progress: 1765546108.294 s, 57781.4 tps, lat 0.340 ms stddev 0.145, 0 failed progress: 1765546113.294 s, 57349.2 tps, lat 0.343 ms stddev 0.146, 0 failed progress: 1765546118.294 s, 57205.5 tps, lat 0.344 ms stddev 0.144, 0 failed progress: 1765546123.294 s, 56764.3 tps, lat 0.346 ms stddev 0.147, 0 failed progress: 1765546128.294 s, 56694.2 tps, lat 0.347 ms stddev 0.155, 0 failed progress: 1765546133.294 s, 56636.1 tps, lat 0.347 ms stddev 0.144, 0 failed progress: 1765546138.294 s, 56498.2 tps, lat 0.348 ms stddev 0.146, 0 failed progress: 1765546143.294 s, 56283.5 tps, lat 0.349 ms stddev 0.146, 0 failed progress: 1765546148.294 s, 56153.6 tps, lat 0.350 ms stddev 0.147, 0 failed progress: 1765546153.294 s, 56238.9 tps, lat 0.350 ms stddev 0.148, 0 failed progress: 1765546158.294 s, 56077.8 tps, lat 0.351 ms stddev 0.148, 0 failed progress: 1765546163.294 s, 56395.6 tps, lat 0.349 ms stddev 0.146, 0 failed progress: 1765546168.294 s, 56297.3 tps, lat 0.349 ms stddev 0.146, 0 failed progress: 1765546173.294 s, 56443.2 tps, lat 0.348 ms stddev 0.145, 0 failed progress: 1765546178.294 s, 56345.4 tps, lat 0.349 ms stddev 0.145, 0 failed progress: 1765546183.294 s, 56386.4 tps, lat 0.349 ms stddev 0.147, 0 failed progress: 1765546188.294 s, 56389.0 tps, lat 0.349 ms stddev 0.150, 0 failed progress: 1765546193.294 s, 56217.2 tps, lat 0.350 ms stddev 0.149, 0 failed progress: 1765546198.294 s, 56250.8 tps, lat 0.350 ms stddev 0.152, 0 failed progress: 1765546203.294 s, 56072.9 tps, lat 0.351 ms stddev 0.151, 0 failed progress: 1765546208.294 s, 56065.7 tps, lat 0.351 ms stddev 0.146, 0 failed progress: 1765546213.294 s, 56176.4 tps, lat 0.350 ms stddev 0.145, 0 failed progress: 1765546218.294 s, 55823.8 tps, lat 0.352 ms stddev 0.146, 0 failed progress: 1765546223.294 s, 56159.1 tps, lat 0.350 ms stddev 0.142, 0 failed progress: 1765546228.294 s, 56028.1 tps, lat 0.351 ms stddev 0.142, 0 failed progress: 1765546233.294 s, 56129.9 tps, lat 0.350 ms stddev 0.143, 0 failed progress: 1765546238.294 s, 56168.9 tps, lat 0.350 ms stddev 0.141, 0 failed progress: 1765546243.294 s, 56247.2 tps, lat 0.349 ms stddev 0.142, 0 failed progress: 1765546248.294 s, 56092.8 tps, lat 0.350 ms stddev 0.146, 0 failed progress: 1765546253.294 s, 56133.7 tps, lat 0.350 ms stddev 0.143, 0 failed progress: 1765546258.294 s, 56178.2 tps, lat 0.350 ms stddev 0.144, 0 failed progress: 1765546263.294 s, 56160.4 tps, lat 0.350 ms stddev 0.143, 0 failed progress: 1765546268.294 s, 56067.4 tps, lat 0.351 ms stddev 0.142, 0 failed progress: 1765546273.294 s, 56113.7 tps, lat 0.350 ms stddev 0.140, 0 failed progress: 1765546278.294 s, 55889.0 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546283.294 s, 56056.4 tps, lat 0.351 ms stddev 0.143, 0 failed progress: 1765546288.294 s, 56131.6 tps, lat 0.350 ms stddev 0.142, 0 failed progress: 1765546293.294 s, 56003.5 tps, lat 0.351 ms stddev 0.143, 0 failed progress: 1765546298.294 s, 56040.5 tps, lat 0.351 ms stddev 0.139, 0 failed progress: 1765546303.294 s, 55905.1 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546308.294 s, 55932.0 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546313.294 s, 55791.3 tps, lat 0.352 ms stddev 0.141, 0 failed progress: 1765546318.294 s, 56021.1 tps, lat 0.351 ms stddev 0.141, 0 failed progress: 1765546323.294 s, 55936.4 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546328.294 s, 55782.7 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546333.294 s, 55716.8 tps, lat 0.353 ms stddev 0.144, 0 failed progress: 1765546338.294 s, 55571.8 tps, lat 0.354 ms stddev 0.145, 0 failed progress: 1765546343.294 s, 55521.4 tps, lat 0.354 ms stddev 0.143, 0 failed progress: 1765546348.294 s, 55767.0 tps, lat 0.353 ms stddev 0.140, 0 failed progress: 1765546353.294 s, 55840.2 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765546358.294 s, 55840.3 tps, lat 0.352 ms stddev 0.144, 0 failed progress: 1765546363.294 s, 55546.0 tps, lat 0.354 ms stddev 0.140, 0 failed progress: 1765546368.294 s, 55789.7 tps, lat 0.352 ms stddev 0.144, 0 failed progress: 1765546373.294 s, 55772.5 tps, lat 0.352 ms stddev 0.143, 0 failed progress: 1765546378.294 s, 55674.0 tps, lat 0.353 ms stddev 0.143, 0 failed progress: 1765546383.294 s, 55580.5 tps, lat 0.354 ms stddev 0.144, 0 failed progress: 1765546388.294 s, 55417.2 tps, lat 0.355 ms stddev 0.142, 0 failed progress: 1765546393.294 s, 55707.8 tps, lat 0.353 ms stddev 0.145, 0 failed progress: 1765546398.294 s, 55542.2 tps, lat 0.354 ms stddev 0.146, 0 failed progress: 1765546403.294 s, 55894.5 tps, lat 0.352 ms stddev 0.143, 0 failed progress: 1765546408.294 s, 55926.0 tps, lat 0.352 ms stddev 0.140, 0 failed progress: 1765546413.294 s, 55600.4 tps, lat 0.354 ms stddev 0.143, 0 failed progress: 1765546418.299 s, 55548.0 tps, lat 0.354 ms stddev 0.141, 0 failed transaction type: ../_bench/cf-5556/a/hot_test.sql scaling factor: 1 query mode: simple number of clients: 20 number of threads: 8 maximum number of tries: 1 duration: 360 s number of transactions actually processed: 20389706 number of failed transactions: 0 (0.000%) latency average = 0.347 ms latency stddev = 0.145 ms initial connection time = 9.011 ms tps = 56638.715544 (without initial connection time) table_name | total_updates | hot_updates | hot_percentage ------------+---------------+-------------+---------------- t | 20389706 | 20380083 | 99.95 (1 row) schemaname | tablename | indexname | idx_scan | idx_tup_read | idx_tup_fetch ------------+-----------+-----------+----------+--------------+--------------- public | t | t_pkey | 20389706 | 20395813 | 20389706 (1 row) relname | n_live_tup | n_dead_tup | dead_pct | last_vacuum | last_autovacuum ---------+------------+------------+----------+-------------+------------------------------- t | 5000 | 0 | 0.00 | | 2025-12-12 08:34:28.502717-05 (1 row)