pgbench (19devel) progress: 1765546808.169 s, 65602.3 tps, lat 0.299 ms stddev 0.142, 0 failed progress: 1765546813.169 s, 62570.1 tps, lat 0.314 ms stddev 0.134, 0 failed progress: 1765546818.169 s, 61340.7 tps, lat 0.321 ms stddev 0.141, 0 failed progress: 1765546823.169 s, 60863.1 tps, lat 0.323 ms stddev 0.139, 0 failed progress: 1765546828.169 s, 60407.0 tps, lat 0.326 ms stddev 0.144, 0 failed progress: 1765546833.169 s, 58721.0 tps, lat 0.335 ms stddev 0.153, 0 failed progress: 1765546838.169 s, 59566.4 tps, lat 0.330 ms stddev 0.149, 0 failed progress: 1765546843.169 s, 58650.7 tps, lat 0.335 ms stddev 0.145, 0 failed progress: 1765546848.169 s, 58056.5 tps, lat 0.339 ms stddev 0.152, 0 failed progress: 1765546853.169 s, 57890.3 tps, lat 0.340 ms stddev 0.146, 0 failed progress: 1765546858.169 s, 57613.9 tps, lat 0.341 ms stddev 0.146, 0 failed progress: 1765546863.169 s, 57045.3 tps, lat 0.345 ms stddev 0.155, 0 failed progress: 1765546868.169 s, 57455.6 tps, lat 0.342 ms stddev 0.149, 0 failed progress: 1765546873.169 s, 57153.1 tps, lat 0.344 ms stddev 0.147, 0 failed progress: 1765546878.169 s, 57054.2 tps, lat 0.345 ms stddev 0.146, 0 failed progress: 1765546883.169 s, 56485.9 tps, lat 0.348 ms stddev 0.150, 0 failed progress: 1765546888.169 s, 56779.8 tps, lat 0.346 ms stddev 0.146, 0 failed progress: 1765546893.169 s, 56518.7 tps, lat 0.348 ms stddev 0.150, 0 failed progress: 1765546898.169 s, 56803.5 tps, lat 0.346 ms stddev 0.148, 0 failed progress: 1765546903.169 s, 56828.7 tps, lat 0.346 ms stddev 0.145, 0 failed progress: 1765546908.169 s, 56692.3 tps, lat 0.347 ms stddev 0.149, 0 failed progress: 1765546913.169 s, 56599.2 tps, lat 0.347 ms stddev 0.146, 0 failed progress: 1765546918.169 s, 56619.7 tps, lat 0.347 ms stddev 0.147, 0 failed progress: 1765546923.171 s, 56553.4 tps, lat 0.348 ms stddev 0.146, 0 failed progress: 1765546928.169 s, 56541.0 tps, lat 0.348 ms stddev 0.147, 0 failed progress: 1765546933.169 s, 56485.8 tps, lat 0.348 ms stddev 0.146, 0 failed progress: 1765546938.169 s, 56377.9 tps, lat 0.349 ms stddev 0.156, 0 failed progress: 1765546943.169 s, 55958.7 tps, lat 0.351 ms stddev 0.151, 0 failed progress: 1765546948.169 s, 56291.2 tps, lat 0.349 ms stddev 0.148, 0 failed progress: 1765546953.169 s, 56467.2 tps, lat 0.348 ms stddev 0.147, 0 failed progress: 1765546958.169 s, 56267.9 tps, lat 0.349 ms stddev 0.151, 0 failed progress: 1765546963.169 s, 56496.5 tps, lat 0.348 ms stddev 0.139, 0 failed progress: 1765546968.169 s, 56280.4 tps, lat 0.349 ms stddev 0.146, 0 failed progress: 1765546973.169 s, 56377.1 tps, lat 0.349 ms stddev 0.141, 0 failed progress: 1765546978.169 s, 56081.8 tps, lat 0.351 ms stddev 0.146, 0 failed progress: 1765546983.169 s, 56055.3 tps, lat 0.351 ms stddev 0.142, 0 failed progress: 1765546988.169 s, 56430.8 tps, lat 0.348 ms stddev 0.141, 0 failed progress: 1765546993.169 s, 56250.5 tps, lat 0.349 ms stddev 0.142, 0 failed progress: 1765546998.169 s, 56193.0 tps, lat 0.350 ms stddev 0.144, 0 failed progress: 1765547003.169 s, 56063.7 tps, lat 0.351 ms stddev 0.144, 0 failed progress: 1765547008.169 s, 56181.7 tps, lat 0.350 ms stddev 0.143, 0 failed progress: 1765547013.169 s, 56113.7 tps, lat 0.350 ms stddev 0.144, 0 failed progress: 1765547018.169 s, 56215.2 tps, lat 0.350 ms stddev 0.142, 0 failed progress: 1765547023.169 s, 56192.0 tps, lat 0.350 ms stddev 0.143, 0 failed progress: 1765547028.169 s, 55851.8 tps, lat 0.352 ms stddev 0.144, 0 failed progress: 1765547033.169 s, 56043.4 tps, lat 0.351 ms stddev 0.143, 0 failed progress: 1765547038.169 s, 55929.4 tps, lat 0.351 ms stddev 0.142, 0 failed progress: 1765547043.169 s, 55845.0 tps, lat 0.352 ms stddev 0.140, 0 failed progress: 1765547048.169 s, 55332.0 tps, lat 0.355 ms stddev 0.148, 0 failed progress: 1765547053.169 s, 55800.3 tps, lat 0.352 ms stddev 0.141, 0 failed progress: 1765547058.169 s, 55691.2 tps, lat 0.353 ms stddev 0.146, 0 failed progress: 1765547063.169 s, 55722.8 tps, lat 0.353 ms stddev 0.144, 0 failed progress: 1765547068.169 s, 55907.4 tps, lat 0.352 ms stddev 0.142, 0 failed progress: 1765547073.169 s, 55247.6 tps, lat 0.356 ms stddev 0.146, 0 failed progress: 1765547078.169 s, 55753.3 tps, lat 0.352 ms stddev 0.143, 0 failed progress: 1765547083.169 s, 55602.9 tps, lat 0.354 ms stddev 0.143, 0 failed progress: 1765547088.169 s, 56078.6 tps, lat 0.351 ms stddev 0.146, 0 failed progress: 1765547093.169 s, 55520.2 tps, lat 0.354 ms stddev 0.143, 0 failed progress: 1765547098.169 s, 55919.5 tps, lat 0.352 ms stddev 0.141, 0 failed progress: 1765547103.169 s, 55386.3 tps, lat 0.355 ms stddev 0.145, 0 failed progress: 1765547108.169 s, 55562.4 tps, lat 0.354 ms stddev 0.144, 0 failed progress: 1765547113.169 s, 55481.5 tps, lat 0.354 ms stddev 0.144, 0 failed progress: 1765547118.169 s, 55409.7 tps, lat 0.355 ms stddev 0.145, 0 failed progress: 1765547123.169 s, 55557.7 tps, lat 0.354 ms stddev 0.144, 0 failed progress: 1765547128.169 s, 55173.7 tps, lat 0.356 ms stddev 0.146, 0 failed progress: 1765547133.169 s, 55129.8 tps, lat 0.357 ms stddev 0.146, 0 failed progress: 1765547138.169 s, 55724.8 tps, lat 0.353 ms stddev 0.143, 0 failed progress: 1765547143.169 s, 54879.1 tps, lat 0.358 ms stddev 0.146, 0 failed progress: 1765547148.169 s, 54758.7 tps, lat 0.359 ms stddev 0.149, 0 failed progress: 1765547153.169 s, 55343.8 tps, lat 0.355 ms stddev 0.143, 0 failed progress: 1765547158.169 s, 54764.9 tps, lat 0.359 ms stddev 0.146, 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: 20401562 number of failed transactions: 0 (0.000%) latency average = 0.347 ms latency stddev = 0.146 ms initial connection time = 12.057 ms tps = 56672.534455 (without initial connection time) table_name | total_updates | hot_updates | hot_percentage ------------+---------------+-------------+---------------- t | 20401562 | 20393424 | 99.96 (1 row) schemaname | tablename | indexname | idx_scan | idx_tup_read | idx_tup_fetch ------------+-----------+-----------+----------+--------------+--------------- public | t | t_pkey | 20401562 | 20406533 | 20401562 (1 row) relname | n_live_tup | n_dead_tup | dead_pct | last_vacuum | last_autovacuum ---------+------------+------------+----------+-------------+------------------------------- t | 5000 | 0 | 0.00 | | 2025-12-12 08:46:09.781718-05 (1 row)