NOTICE:  Skipping "pg_group" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_database" --- only table or database owner can VACUUM it
NOTICE:  Skipping "pg_shadow" --- only table or database owner can VACUUM it
NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..1343.81 rows=199 width=24) (actual time=101.51..3583.62 rows=181 loops=1)
  ->  Nested Loop  (cost=0.00..741.80 rows=199 width=16) (actual time=71.32..1990.54 rows=181 loops=1)
        ->  Index Scan using indexjointest3_1_infoa on jointest3_1  (cost=0.00..420.65 rows=105 width=8) (actual time=25.48..856.21 rows=92 loops=1)
        ->  Index Scan using indexjointest3_2_keya on jointest3_2  (cost=0.00..3.03 rows=2 width=8) (actual time=12.31..12.32 rows=2 loops=92)
  ->  Index Scan using indexjointest3_3_keyb on jointest3_3  (cost=0.00..3.01 rows=1 width=8) (actual time=8.79..8.80 rows=1 loops=181)
Total runtime: 3583.96 msec

NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..1343.81 rows=199 width=24) (actual time=0.32..23.74 rows=181 loops=1)
  ->  Nested Loop  (cost=0.00..741.80 rows=199 width=16) (actual time=0.25..10.50 rows=181 loops=1)
        ->  Index Scan using indexjointest3_1_infoa on jointest3_1  (cost=0.00..420.65 rows=105 width=8) (actual time=0.16..3.49 rows=92 loops=1)
        ->  Index Scan using indexjointest3_2_keya on jointest3_2  (cost=0.00..3.03 rows=2 width=8) (actual time=0.07..0.07 rows=2 loops=92)
  ->  Index Scan using indexjointest3_3_keyb on jointest3_3  (cost=0.00..3.01 rows=1 width=8) (actual time=0.07..0.07 rows=1 loops=181)
Total runtime: 23.96 msec

NOTICE:  QUERY PLAN:

Hash Join  (cost=426.08..101497.21 rows=201 width=24) (actual time=319.68..15399.50 rows=224 loops=1)
  ->  Merge Join  (cost=0.00..86902.39 rows=1888831 width=16) (actual time=28.48..13852.19 rows=2000000 loops=1)
        ->  Index Scan using indexjointest3_1_keya on jointest3_1  (cost=0.00..18599.00 rows=1000000 width=8) (actual time=28.30..2474.90 rows=1000000 loops=1)
        ->  Index Scan using indexjointest3_2_keya on jointest3_2  (cost=0.00..37193.00 rows=2000000 width=8) (actual time=0.15..5663.64 rows=2000000 loops=1)
  ->  Hash  (cost=425.81..425.81 rows=107 width=8) (actual time=217.25..217.25 rows=0 loops=1)
        ->  Index Scan using indexjointest3_3_infob on jointest3_3  (cost=0.00..425.81 rows=107 width=8) (actual time=24.98..217.09 rows=112 loops=1)
Total runtime: 15420.55 msec

NOTICE:  QUERY PLAN:

Hash Join  (cost=426.08..101497.21 rows=201 width=24) (actual time=363.25..14638.78 rows=224 loops=1)
  ->  Merge Join  (cost=0.00..86902.39 rows=1888831 width=16) (actual time=36.47..13099.69 rows=2000000 loops=1)
        ->  Index Scan using indexjointest3_1_keya on jointest3_1  (cost=0.00..18599.00 rows=1000000 width=8) (actual time=28.30..2486.89 rows=1000000 loops=1)
        ->  Index Scan using indexjointest3_2_keya on jointest3_2  (cost=0.00..37193.00 rows=2000000 width=8) (actual time=8.14..4948.04 rows=2000000 loops=1)
  ->  Hash  (cost=425.81..425.81 rows=107 width=8) (actual time=246.15..246.15 rows=0 loops=1)
        ->  Index Scan using indexjointest3_3_infob on jointest3_3  (cost=0.00..425.81 rows=107 width=8) (actual time=53.91..245.99 rows=112 loops=1)
Total runtime: 14639.31 msec

NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..4010.50 rows=201 width=24) (actual time=56.30..893.31 rows=224 loops=1)
  ->  Nested Loop  (cost=0.00..3365.04 rows=213 width=16) (actual time=56.13..876.68 rows=224 loops=1)
        ->  Index Scan using indexjointest3_3_infob on jointest3_3  (cost=0.00..425.81 rows=107 width=8) (actual time=0.18..4.18 rows=112 loops=1)
        ->  Index Scan using indexjointest3_2_keyb on jointest3_2  (cost=0.00..27.48 rows=6 width=8) (actual time=7.75..7.78 rows=2 loops=112)
  ->  Index Scan using indexjointest3_1_keya on jointest3_1  (cost=0.00..3.01 rows=1 width=8) (actual time=0.07..0.07 rows=1 loops=224)
Total runtime: 893.62 msec

NOTICE:  QUERY PLAN:

Nested Loop  (cost=0.00..4010.50 rows=201 width=24) (actual time=0.39..40.16 rows=224 loops=1)
  ->  Nested Loop  (cost=0.00..3365.04 rows=213 width=16) (actual time=0.32..16.79 rows=224 loops=1)
        ->  Index Scan using indexjointest3_3_infob on jointest3_3  (cost=0.00..425.81 rows=107 width=8) (actual time=0.14..4.05 rows=112 loops=1)
        ->  Index Scan using indexjointest3_2_keyb on jointest3_2  (cost=0.00..27.48 rows=6 width=8) (actual time=0.07..0.11 rows=2 loops=112)
  ->  Index Scan using indexjointest3_1_keya on jointest3_1  (cost=0.00..3.01 rows=1 width=8) (actual time=0.10..0.10 rows=1 loops=224)
Total runtime: 40.39 msec