#	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)

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)
  ->  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))
        ->  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)
              ->  Seq Scan on dlk_poly  (cost=0.00..1523.98 rows=48098 width=8) (actual time=0.004..29.823 rows=48098 loops=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
                    ->  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))
        ->  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
              ->  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)))
  ->  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
        ->  Function Scan on crosstab ct  (cost=0.00..10.00 rows=1000 width=40) (actual time=1999.572..1999.573 rows=1 loops=1)
Total runtime: 62102.478 ms

Per node type stats

node type	count	sum of times	% of query
Function Scan	1	1999.573 ms	3.2 %
Hash	3	56328.178 ms	90.7 %
Hash Join	3	2508.836 ms	4.0 %
Seq Scan	3	1263.873 ms	2.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dlk_poly	1	29.823 ms	0.0 %
Seq Scan	1	29.823 ms	100.0 %
gkimmtb	1	104.526 ms	0.2 %
Seq Scan	1	104.526 ms	100.0 %
polygons	1	1129.524 ms	1.8 %
Seq Scan	1	1129.524 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: LyM

Colorize:

Columns visibility:

Per node type stats

Per table stats