test-after.txt
text/plain
effective_io_concurrency=0
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=71320.201..71320.201 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=620.222..620.222 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 25.095 ms
Execution time: 71321.723 ms
(12 rows)
effective_io_concurrency=1
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=180229.423..180229.423 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=626.718..626.718 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 14.123 ms
Execution time: 180230.742 ms
(12 rows)
effective_io_concurrency=2
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=98634.125..98634.125 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=620.905..620.905 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 22.936 ms
Execution time: 98635.566 ms
(12 rows)
effective_io_concurrency=4
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=91463.095..91463.095 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=643.029..643.029 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 13.676 ms
Execution time: 91464.375 ms
(12 rows)
effective_io_concurrency=8
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=91047.653..91047.653 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=614.786..614.786 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 15.338 ms
Execution time: 91048.939 ms
(12 rows)
effective_io_concurrency=16
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=97680.861..97680.861 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=616.763..616.763 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 16.479 ms
Execution time: 97682.475 ms
(12 rows)
effective_io_concurrency=8
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=91260.958..91260.958 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=596.291..596.291 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 16.734 ms
Execution time: 91262.404 ms
(12 rows)
effective_io_concurrency=4
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=90944.102..90944.102 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=597.324..597.324 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 16.300 ms
Execution time: 90945.560 ms
(12 rows)
effective_io_concurrency=2
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=97018.175..97018.175 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=645.782..645.782 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 13.976 ms
Execution time: 97019.504 ms
(12 rows)
effective_io_concurrency=1
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=180330.061..180330.061 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=610.894..610.894 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 16.558 ms
Execution time: 180331.474 ms
(12 rows)
effective_io_concurrency=0
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on pgbench_accounts (cost=13070.16..358509.72 rows=1 width=97) (actual time=71467.974..71467.974 rows=0 loops=1)
Recheck Cond: ((aid >= 1000) AND (aid <= 1000000))
Rows Removed by Index Recheck: 11433521
Filter: (abalance <> 0)
Rows Removed by Filter: 999001
Heap Blocks: exact=115112 lossy=198588
Buffers: shared hit=3 read=316430
-> Bitmap Index Scan on pgbench_accounts_pkey (cost=0.00..13070.16 rows=1004032 width=0) (actual time=778.875..778.875 rows=999001 loops=1)
Index Cond: ((aid >= 1000) AND (aid <= 1000000))
Buffers: shared hit=2 read=2731
Planning time: 42.094 ms
Execution time: 71469.484 ms
(12 rows)