explain.depesz.com

A tool for finding a real cause for slow queries.

Result: LyM

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 16.588 62100.460 ↓ 1.6 4125 1

Hash Join (cost=119709.95..166577.87 rows=2505 width=1142) (actual time=59605.648..62100.460 rows=4125 loops=1)

  • Hash Cond: ((gkimmtb.imm_ccmpccmp)::text = ct.ind_ccmpccmp)
2. 2422.050 60084.296 ↓ 8.2 4126 1

Hash Join (cost=119687.45..166247.26 rows=501 width=1102) (actual time=57606.031..60084.296 rows=4126 loops=1)

  • Hash Cond: ((dlk_poly.gid = polygons.gid) AND ((gkimmtb.imm_ccomammi)::bpchar = (polygons.codamm)::bpchar))
3. 70.198 247.362 ↑ 2.8 16888 1

Hash Join (cost=5635.74..8924.80 rows=48098 width=37) (actual time=149.100..247.362 rows=16888 loops=1)

  • Hash Cond: (dlk_poly.cimm = gkimmtb.imm_ckimcimm)
4. 29.823 29.823 ↑ 1.0 48098 1

Seq Scan on dlk_poly (cost=0.00..1523.98 rows=48098 width=8) (actual time=0.004..29.823 rows=48098 loops=1)

5. 42.815 147.341 ↑ 1.0 51769 1

Hash (cost=4598.14..4598.14 rows=53648 width=29) (actual time=147.341..147.341 rows=51769 loops=1)

  • Buckets: 2048 Batches: 4 Memory Usage: 801kB
6. 104.526 104.526 ↑ 1.0 51769 1

Seq Scan on gkimmtb (cost=0.00..4598.14 rows=53648 width=29) (actual time=1.115..104.526 rows=51769 loops=1)

  • Filter: (((imm_cimmccls)::bpchar <> ''::bpchar) AND (imm_cmutafin = 0) AND ("substring"((imm_cimmccls)::text, 1, 3) <> '999'::text) AND ("substring"((imm_cimmccls)::text, 1, 3) <> '888'::text) AND ("substring"((imm_cimmccls)::text, 1, 3) <> '777'::text))
7. 56285.360 57414.884 ↓ 1.3 400044 1

Hash (cost=67172.69..67172.69 rows=315068 width=1069) (actual time=57414.884..57414.884 rows=400044 loops=1)

  • Buckets: 1024 Batches: 512 Memory Usage: 300kB
8. 1129.524 1129.524 ↓ 1.3 400044 1

Seq Scan on polygons (cost=0.00..67172.69 rows=315068 width=1069) (actual time=0.430..1129.524 rows=400044 loops=1)

  • Filter: ((new_path_file IS NULL) AND (((layer)::text = 'FABBRICATO'::text) OR ((layer)::text = 'PARTICELLA'::text)) AND (((layer)::text = 'PARTICELLA'::text) OR ((layer)::text = 'ACQUA'::text) OR ((layer)::text = 'STRADA'::text)))
9. 0.003 1999.576 ↑ 1000.0 1 1

Hash (cost=10.00..10.00 rows=1000 width=40) (actual time=1999.576..1999.576 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
10. 1999.573 1999.573 ↑ 1000.0 1 1

Function Scan on crosstab ct (cost=0.00..10.00 rows=1000 width=40) (actual time=1999.572..1999.573 rows=1 loops=1)