Original query:

QUERY PLAN                                                                                                      
 Nested Loop  (cost=89481.24..115827.36 rows=1 width=4) (actual time=20086.172..1519160.184 rows=588 loops=1)
   Join Filter: ((pp.parcel_id)::text = (pp2.parcel_id)::text)
   Rows Removed by Join Filter: 3463718566
   ->  Nested Loop  (cost=89480.81..115700.34 rows=83 width=13) (actual time=821.180..111268.215 rows=123736001 loops=1)
         ->  Hash Join  (cost=89480.38..115544.29 rows=59 width=8) (actual time=821.159..12929.137 rows=60795145 loops=1)
               Hash Cond: ((jk.gnr = p2.gnr) AND (jk.bnr = p2.bnr))
               ->  Hash Join  (cost=149.03..484.88 rows=167 width=10) (actual time=1.561..78.831 rows=409445 loops=1)
                     Hash Cond: (pgp.fnr = jk.fnr)
                     ->  Nested Loop  (cost=1.27..312.99 rows=36 width=8) (actual time=0.095..7.479 rows=85 loops=1)
                           ->  Nested Loop  (cost=0.84..181.62 rows=100 width=8) (actual time=0.066..3.523 rows=86 loops=1)
                                 ->  Index Scan using uidx_org_property_property_group_municipality_nr_name on property_group pg  (cost=0.42..47.39 rows=66 width=4) (actual time=0.039..0.784 rows=66 loops=1)
                                       Index Cond: (municipality_nr = 2004)
                                 ->  Index Only Scan using idx_org_property_property_group_property_sub on property_group_property pgp  (cost=0.42..2.01 rows=2 width=12) (actual time=0.014..0.029 rows=1 loops=66)
                                       Index Cond: (property_group_ref = pg.id)
                                       Heap Fetches: 60
                           ->  Index Scan using property_municipality_nr_gnr_bnr_fnr_key on property p  (cost=0.43..1.31 rows=1 width=12) (actual time=0.027..0.027 rows=1 loops=86)
                                 Index Cond: ((municipality_nr = 2004) AND (gnr = pgp.gnr) AND (bnr = pgp.bnr) AND (fnr = pgp.fnr))
                     ->  Hash  (cost=85.67..85.67 rows=4967 width=8) (actual time=1.438..1.439 rows=4967 loops=1)
                           Buckets: 8192  Batches: 1  Memory Usage: 259kB
                           ->  Seq Scan on sl_lop_temp_jordreg_rep4_ar5_areal jk  (cost=0.00..85.67 rows=4967 width=8) (actual time=0.018..0.941 rows=4967 loops=1)
               ->  Hash  (cost=39959.94..39959.94 rows=2830694 width=10) (actual time=815.086..815.086 rows=2801543 loops=1)
                     Buckets: 1048576  Batches: 8  Memory Usage: 23311kB
                     ->  Seq Scan on property p2  (cost=0.00..39959.94 rows=2830694 width=10) (actual time=0.013..422.468 rows=2801543 loops=1)
         ->  Index Scan using idx_org_property_property_parcel_property_ref on property_parcel pp  (cost=0.43..2.61 rows=4 width=13) (actual time=0.001..0.001 rows=2 loops=60795145)
               Index Cond: (property_ref = p.id)
   ->  Index Scan using idx_org_property_property_parcel_property_ref on property_parcel pp2  (cost=0.43..1.48 rows=4 width=13) (actual time=0.002..0.009 rows=28 loops=123736001)
         Index Cond: (property_ref = p2.id)
 Planning Time: 8.919 ms
 Execution Time: 1519163.330 ms
(29 rows)