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. 1.611 981.962 ↓ 2.3 64 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

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

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

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. 1.112 2.153 ↓ 3.4 173 3

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

8. 0.609 1.028 ↓ 2.4 85 3

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

9. 0.241 0.412 ↑ 1.2 86 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

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.003 0.003 ↑ 2.0 1 198

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.007 0.007 ↑ 1.0 1 258

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. 0.013 0.013 ↑ 2.0 2 255

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. 0.024 0.024 ↑ 1.0 1 192

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