explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hyNg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,005.623 ↓ 588.0 588 1

Hash Join (cost=1,581.88..232,545.35 rows=1 width=4) (actual time=11.727..1,005.623 rows=588 loops=1)

  • Hash Cond: ((p2.gnr = jk.gnr) AND (p2.bnr = jk.bnr) AND (p2.fnr = jk.fnr))
2. 54.393 1,036.355 ↓ 2.9 192 1

Gather (cost=1,409.29..232,249.25 rows=66 width=8) (actual time=10.214..1,036.355 rows=192 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.099 981.962 ↓ 2.3 64 3 / 3

Nested Loop (cost=409.29..231,242.65 rows=28 width=8) (actual time=36.936..981.962 rows=64 loops=3)

4. 138.867 980.327 ↓ 2.3 64 3 / 3

Hash Join (cost=408.86..231,206.86 rows=28 width=4) (actual time=36.844..980.327 rows=64 loops=3)

  • Hash Cond: ((pp2.parcel_id)::text = (pp.parcel_id)::text)
5. 839.271 839.271 ↑ 1.3 1,305,474 3 / 3

Parallel Seq Scan on property_parcel pp2 (cost=0.00..224,498.08 rows=1,679,908 width=13) (actual time=0.014..839.271 rows=1,305,474 loops=3)

6. 0.036 2.189 ↓ 3.4 173 3 / 3

Hash (cost=408.22..408.22 rows=51 width=9) (actual time=2.188..2.189 rows=173 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
7. 0.020 2.153 ↓ 3.4 173 3 / 3

Nested Loop (cost=1.70..408.22 rows=51 width=9) (actual time=0.227..2.153 rows=173 loops=3)

8. 0.014 1.028 ↓ 2.4 85 3 / 3

Nested Loop (cost=1.27..313.00 rows=36 width=4) (actual time=0.175..1.028 rows=85 loops=3)

9. 0.046 0.412 ↑ 1.2 86 3 / 3

Nested Loop (cost=0.84..181.62 rows=100 width=8) (actual time=0.121..0.412 rows=86 loops=3)

10. 0.168 0.168 ↑ 1.0 66 3 / 3

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.059..0.168 rows=66 loops=3)

  • Index Cond: (municipality_nr = 2004)
11. 0.198 0.198 ↑ 2.0 1 198 / 3

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.003..0.003 rows=1 loops=198)

  • Index Cond: (property_group_ref = pg.id)
  • Heap Fetches: 255
12. 0.602 0.602 ↑ 1.0 1 258 / 3

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.007..0.007 rows=1 loops=258)

  • Index Cond: ((municipality_nr = 2004) AND (gnr = pgp.gnr) AND (bnr = pgp.bnr) AND (fnr = pgp.fnr))
13. 1.105 1.105 ↑ 2.0 2 255 / 3

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.010..0.013 rows=2 loops=255)

  • Index Cond: (property_ref = p.id)
14. 1.536 1.536 ↑ 1.0 1 192 / 3

Index Scan using property_pkey on property p2 (cost=0.43..1.28 rows=1 width=12) (actual time=0.024..0.024 rows=1 loops=192)

  • Index Cond: (id = pp2.property_ref)
15. 0.643 1.474 ↑ 1.0 4,967 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 259kB
16. 0.831 0.831 ↑ 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.021..0.831 rows=4,967 loops=1)

Planning time : 7.468 ms
Execution time : 1,038.586 ms