====================== eic 1 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191281 I/O Timings: shared read=3013.116 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191281 I/O Timings: shared read=3013.116 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 31.996 Prefetch Count: 163951 Prefetch Stalls: 1 Prefetch Skips: 9837060 Prefetch Resets: 3 Buffers: shared read=191281 I/O Timings: shared read=3013.116 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.550 Planning Time: 6.822 ms Execution Time: 5279.929 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 6710.00 268196.50 0.00 0.00 0.10 39.97 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.64 60.00 nvme0n1p1 7122.00 289432.00 0.00 0.00 0.09 40.64 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.63 62.00 nvme0n1p1 6811.00 276864.00 0.00 0.00 0.10 40.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.66 63.60 nvme0n1p1 7209.00 293144.00 0.00 0.00 0.09 40.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.65 72.80 nvme0n1p1 7519.00 306128.00 0.00 0.00 0.08 40.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.64 65.60 ====================== eic 8 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2625.972 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2625.972 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2625.972 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.656 Planning Time: 6.605 ms Execution Time: 5102.460 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 7681.00 278516.00 0.00 0.00 0.11 36.26 19.00 143.00 0.00 0.00 0.11 7.53 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 52.40 nvme0n1p1 8316.00 305400.00 0.00 0.00 0.11 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 62.00 nvme0n1p1 7695.00 282568.00 0.00 0.00 0.12 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.90 64.80 nvme0n1p1 8350.00 307192.00 0.00 0.00 0.11 36.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 55.60 nvme0n1p1 8399.00 308768.00 0.00 0.00 0.11 36.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 60.80 ====================== eic 16 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2705.352 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2705.352 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2705.352 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=3.004 Planning Time: 7.725 ms Execution Time: 5308.190 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 7107.00 256981.00 0.00 0.00 0.11 36.16 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.78 51.60 nvme0n1p1 7879.00 289552.00 0.00 0.00 0.10 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.81 49.20 nvme0n1p1 7671.00 281904.00 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.82 55.20 nvme0n1p1 8136.00 298944.00 0.00 0.00 0.10 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.84 59.20 nvme0n1p1 7933.00 291688.00 0.00 0.00 0.11 36.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 56.80 ====================== eic 32 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2931.130 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2931.130 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2931.130 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.921 Planning Time: 6.654 ms Execution Time: 5572.837 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 6674.00 241316.00 0.00 0.00 0.12 36.16 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.79 61.20 nvme0n1p1 7342.00 269680.00 0.00 0.00 0.11 36.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.84 57.60 nvme0n1p1 7713.86 283516.83 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 59.41 nvme0n1p1 6987.00 256696.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.80 58.40 nvme0n1p1 7835.00 288344.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.80 54.00 ====================== eic 64 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2661.311 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2661.311 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2661.311 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.675 Planning Time: 6.858 ms Execution Time: 5239.994 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 6942.00 251236.00 0.00 0.00 0.12 36.19 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 62.00 nvme0n1p1 8176.00 300400.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 73.60 nvme0n1p1 7938.00 291496.00 0.00 0.00 0.11 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 72.80 nvme0n1p1 8235.00 302680.00 0.00 0.00 0.10 36.76 1.00 8.00 0.00 0.00 0.00 8.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 60.80 nvme0n1p1 8155.00 300080.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.85 59.60 ====================== eic 128 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2607.508 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2607.508 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2607.508 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.742 Planning Time: 7.629 ms Execution Time: 5110.434 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 7380.00 267116.50 0.00 0.00 0.12 36.19 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 70.40 nvme0n1p1 8236.00 302600.00 0.00 0.00 0.10 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 66.00 nvme0n1p1 7988.12 293394.06 0.00 0.00 0.11 36.73 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 61.78 nvme0n1p1 8310.00 305424.00 0.00 0.00 0.10 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 65.60 nvme0n1p1 8542.00 314264.00 0.00 0.00 0.10 36.79 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 60.00 ====================== eic 256 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2540.047 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2540.047 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2540.047 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.644 Planning Time: 6.982 ms Execution Time: 5036.594 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 7847.00 284436.00 0.00 0.00 0.11 36.25 1.00 9.50 0.00 0.00 0.00 9.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 56.80 nvme0n1p1 7730.00 284024.00 0.00 0.00 0.11 36.74 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 62.40 nvme0n1p1 8462.00 310752.00 0.00 0.00 0.10 36.72 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 62.80 nvme0n1p1 8352.00 307328.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 74.40 nvme0n1p1 8719.00 320712.00 0.00 0.00 0.10 36.78 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 55.60 ====================== eic 512 ======================== SET QUERY PLAN ---------------------------------------------------------------------------------------------------------- Aggregate (actual rows=1.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2510.486 -> Limit (actual rows=10000000.00 loops=1) Buffers: shared read=191271 I/O Timings: shared read=2510.486 -> Index Scan using pgbench_accounts_pkey on pgbench_accounts (actual rows=10000000.00 loops=1) Index Searches: 1 Prefetch Distance: 58.116 Prefetch Count: 163944 Prefetch Stalls: 1188 Prefetch Skips: 9836640 Prefetch Resets: 1190 Buffers: shared read=191271 I/O Timings: shared read=2510.486 Planning: Buffers: shared hit=46 read=22 I/O Timings: shared read=2.700 Planning Time: 7.197 ms Execution Time: 5037.071 ms (20 rows) Device r/s rkB/s rrqm/s %rrqm r_await rareq-sz w/s wkB/s wrqm/s %wrqm w_await wareq-sz d/s dkB/s drqm/s %drqm d_await dareq-sz f/s f_await aqu-sz %util nvme0n1p1 7379.00 267108.50 0.00 0.00 0.12 36.20 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.86 60.80 nvme0n1p1 8128.00 298680.00 0.00 0.00 0.11 36.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 62.00 nvme0n1p1 8437.00 309752.00 0.00 0.00 0.11 36.71 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.89 53.60 nvme0n1p1 8609.00 316528.00 0.00 0.00 0.10 36.77 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.88 60.00 nvme0n1p1 8534.00 314016.00 0.00 0.00 0.10 36.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.87 68.80