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)