explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhBt

Settings
# exclusive inclusive rows x rows loops node
1. 294,267.960 1,519,160.184 ↓ 588.0 588 1

Nested Loop (cost=89,481.24..115,827.36 rows=1 width=4) (actual time=20,086.172..1,519,160.184 rows=588 loops=1)

  • Join Filter: ((pp.parcel_id)::text = (pp2.parcel_id)::text)
  • Rows Removed by Join Filter: 3463718566
2. 37,543.933 111,268.215 ↓ 1,490,795.2 123,736,001 1

Nested Loop (cost=89,480.81..115,700.34 rows=83 width=13) (actual time=821.180..111,268.215 rows=123,736,001 loops=1)

3. 12,035.220 12,929.137 ↓ 1,030,426.2 60,795,145 1

Hash Join (cost=89,480.38..115,544.29 rows=59 width=8) (actual time=821.159..12,929.137 rows=60,795,145 loops=1)

  • Hash Cond: ((jk.gnr = p2.gnr) AND (jk.bnr = p2.bnr))
4. 69.913 78.831 ↓ 2,451.8 409,445 1

Hash Join (cost=149.03..484.88 rows=167 width=10) (actual time=1.561..78.831 rows=409,445 loops=1)

  • Hash Cond: (pgp.fnr = jk.fnr)
5. 1.634 7.479 ↓ 2.4 85 1

Nested Loop (cost=1.27..312.99 rows=36 width=8) (actual time=0.095..7.479 rows=85 loops=1)

6. 0.825 3.523 ↑ 1.2 86 1

Nested Loop (cost=0.84..181.62 rows=100 width=8) (actual time=0.066..3.523 rows=86 loops=1)

7. 0.784 0.784 ↑ 1.0 66 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)
8. 1.914 1.914 ↑ 2.0 1 66

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
9. 2.322 2.322 ↑ 1.0 1 86

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))
10. 0.498 1.439 ↑ 1.0 4,967 1

Hash (cost=85.67..85.67 rows=4,967 width=8) (actual time=1.438..1.439 rows=4,967 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 259kB
11. 0.941 0.941 ↑ 1.0 4,967 1

Seq Scan on sl_lop_temp_jordreg_rep4_ar5_areal jk (cost=0.00..85.67 rows=4,967 width=8) (actual time=0.018..0.941 rows=4,967 loops=1)

12. 392.618 815.086 ↑ 1.0 2,801,543 1

Hash (cost=39,959.94..39,959.94 rows=2,830,694 width=10) (actual time=815.086..815.086 rows=2,801,543 loops=1)

  • Buckets: 1048576 Batches: 8 Memory Usage: 23311kB
13. 422.468 422.468 ↑ 1.0 2,801,543 1

Seq Scan on property p2 (cost=0.00..39,959.94 rows=2,830,694 width=10) (actual time=0.013..422.468 rows=2,801,543 loops=1)

14. 60,795.145 60,795.145 ↑ 2.0 2 60,795,145

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=60,795,145)

  • Index Cond: (property_ref = p.id)
15. 1,113,624.009 1,113,624.009 ↓ 7.0 28 123,736,001

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=123,736,001)

  • Index Cond: (property_ref = p2.id)
Planning time : 8.919 ms
Execution time : 1,519,163.330 ms