#	exclusive	inclusive	rows x	rows	loops	node
1.	0.003	600.468	↑ 1.0	1	1	→ Limit (cost=11843.36..168950.61 rows=1 width=972) (actual time=600.467..600.468 rows=1 loops=1)
2.	0.006	600.465	↑ 1.0	1	1	→ Nested Loop Left Join (cost=11843.36..168950.61 rows=1 width=972) (actual time=600.465..600.465 rows=1 loops=1)
3.	2.946	600.446	↑ 1.0	1	1	→ Hash Join (cost=11843.36..168940.41 rows=1 width=972) (actual time=600.446..600.446 rows=1 loops=1) Hash Cond: (((polygons.codamm)::text = (gkclmtb.clm_ccomammi)::text) AND ((polygons.sezione)::bpchar = CASE WHEN ((gkclmtb.clm_csezcsez)::bpchar = ''::bpchar) THEN '_'::bpchar WHEN ((gkclmtb.clm_csezcsez)::bpchar = ' '::bpchar) THEN '_'::bpchar ELSE NULL::bpchar END) AND ((polygons.foglio)::text = (gkclmtb.clm_nfognume)::text) AND ((polygons.numero)::text = (gkclmtb.clm_nmcpnume)::text))
4.	0.180	0.180	↑ 1147.8	104	1	→ Seq Scan on polygons (cost=0.00..98605.25 rows=119371 width=976) (actual time=0.014..0.180 rows=104 loops=1) Filter: ((new_path_file IS NULL) AND ((layer)::text = 'FABBRICATO'::text) AND (((layer)::text = 'FABBRICATO'::text) OR ((layer)::text = 'PARTICELLA'::text)))
5.	145.728	597.320	↓ 8.1	129140	1	→ Hash (cost=11525.64..11525.64 rows=15886 width=19) (actual time=597.320..597.320 rows=129140 loops=1) Buckets: 2048 Batches: 8 (originally 1) Memory Usage: 1025kB
6.	345.853	451.592	↓ 8.1	129140	1	→ Hash Join (cost=2.27..11525.64 rows=15886 width=19) (actual time=0.126..451.592 rows=129140 loops=1) Hash Cond: (((gkclmtb.clm_cazicazi)::text = (gkclstb.cls_cazicazi)::text) AND ((gkclmtb.clm_ccmpccmp)::text = (gkclstb.cls_ccmpccmp)::text) AND (gkclmtb.clm_npdciden = gkclstb.cls_npdciden) AND ((gkclmtb.clm_ccatccat)::text = (gkclstb.cls_ccatccat)::text) AND ((gkclmtb.clm_cclscodi)::text = (gkclstb.cls_cclscodi)::text))
7.	105.666	105.666	↑ 1.0	255670	1	→ Seq Scan on gkclmtb (cost=0.00..6570.70 rows=255670 width=56) (actual time=0.036..105.666 rows=255670 loops=1)
8.	0.043	0.073	↑ 1.0	39	1	→ Hash (cost=1.39..1.39 rows=39 width=53) (actual time=0.073..0.073 rows=39 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 4kB
9.	0.030	0.030	↑ 1.0	39	1	→ Seq Scan on gkclstb (cost=0.00..1.39 rows=39 width=53) (actual time=0.003..0.030 rows=39 loops=1)
10.	0.013	0.013	↑ 2.0	1	1	→ Index Scan using fld_poly_gid on dlk_poly (cost=0.00..10.18 rows=2 width=4) (actual time=0.013..0.013 rows=1 loops=1) Index Cond: (polygons.gid = dlk_poly.gid)

"Limit  (cost=11843.36..168950.61 rows=1 width=972) (actual time=600.467..600.468 rows=1 loops=1)"
"  ->  Nested Loop Left Join  (cost=11843.36..168950.61 rows=1 width=972) (actual time=600.465..600.465 rows=1 loops=1)"
"        ->  Hash Join  (cost=11843.36..168940.41 rows=1 width=972) (actual time=600.446..600.446 rows=1 loops=1)"
"              Hash Cond: (((polygons.codamm)::text = (gkclmtb.clm_ccomammi)::text) AND ((polygons.sezione)::bpchar = CASE WHEN ((gkclmtb.clm_csezcsez)::bpchar = ''::bpchar) THEN '_'::bpchar WHEN ((gkclmtb.clm_csezcsez)::bpchar = ' '::bpchar) THEN '_'::bpchar ELSE NULL::bpchar END) AND ((polygons.foglio)::text = (gkclmtb.clm_nfognume)::text) AND ((polygons.numero)::text = (gkclmtb.clm_nmcpnume)::text))"
"              ->  Seq Scan on polygons  (cost=0.00..98605.25 rows=119371 width=976) (actual time=0.014..0.180 rows=104 loops=1)"
"                    Filter: ((new_path_file IS NULL) AND ((layer)::text = 'FABBRICATO'::text) AND (((layer)::text = 'FABBRICATO'::text) OR ((layer)::text = 'PARTICELLA'::text)))"
"              ->  Hash  (cost=11525.64..11525.64 rows=15886 width=19) (actual time=597.320..597.320 rows=129140 loops=1)"
"                    Buckets: 2048  Batches: 8 (originally 1)  Memory Usage: 1025kB"
"                    ->  Hash Join  (cost=2.27..11525.64 rows=15886 width=19) (actual time=0.126..451.592 rows=129140 loops=1)"
"                          Hash Cond: (((gkclmtb.clm_cazicazi)::text = (gkclstb.cls_cazicazi)::text) AND ((gkclmtb.clm_ccmpccmp)::text = (gkclstb.cls_ccmpccmp)::text) AND (gkclmtb.clm_npdciden = gkclstb.cls_npdciden) AND ((gkclmtb.clm_ccatccat)::text = (gkclstb.cls_ccatccat)::text) AND ((gkclmtb.clm_cclscodi)::text = (gkclstb.cls_cclscodi)::text))"
"                          ->  Seq Scan on gkclmtb  (cost=0.00..6570.70 rows=255670 width=56) (actual time=0.036..105.666 rows=255670 loops=1)"
"                          ->  Hash  (cost=1.39..1.39 rows=39 width=53) (actual time=0.073..0.073 rows=39 loops=1)"
"                                Buckets: 1024  Batches: 1  Memory Usage: 4kB"
"                                ->  Seq Scan on gkclstb  (cost=0.00..1.39 rows=39 width=53) (actual time=0.003..0.030 rows=39 loops=1)"
"        ->  Index Scan using fld_poly_gid on dlk_poly  (cost=0.00..10.18 rows=2 width=4) (actual time=0.013..0.013 rows=1 loops=1)"
"              Index Cond: (polygons.gid = dlk_poly.gid)"
"Total runtime: 608.313 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	2	145.771 ms	24.3 %
Hash Join	2	348.799 ms	58.1 %
Index Scan	1	0.013 ms	0.0 %
Limit	1	0.003 ms	0.0 %
Nested Loop Left Join	1	0.006 ms	0.0 %
Seq Scan	3	105.876 ms	17.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
dlk_poly	1	0.013 ms	0.0 %
Index Scan	1	0.013 ms	100.0 %
gkclmtb	1	105.666 ms	17.6 %
Seq Scan	1	105.666 ms	100.0 %
gkclstb	1	0.030 ms	0.0 %
Seq Scan	1	0.030 ms	100.0 %
polygons	1	0.180 ms	0.0 %
Seq Scan	1	0.180 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 7ZE

Colorize:

Columns visibility:

Per node type stats

Per table stats