#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	680.451	↑ 1.0	1	1	→ Limit (cost=11844.95..172783.48 rows=1 width=1025) (actual time=680.451..680.451 rows=1 loops=1)
2.	0.006	680.449	↑ 1.0	1	1	→ Nested Loop Left Join (cost=11844.95..172783.48 rows=1 width=1025) (actual time=680.449..680.449 rows=1 loops=1)
3.	2.927	680.430	↑ 1.0	1	1	→ Hash Join (cost=11844.95..172773.28 rows=1 width=1025) (actual time=680.430..680.430 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.203	0.203	↑ 1206.8	104	1	→ Seq Scan on polygons (cost=0.00..99431.85 rows=125503 width=1029) (actual time=0.009..0.203 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.978	677.300	↓ 8.1	129140	1	→ Hash (cost=11526.17..11526.17 rows=15939 width=19) (actual time=677.300..677.300 rows=129140 loops=1) Buckets: 2048 Batches: 8 (originally 1) Memory Usage: 1025kB
6.	344.898	531.322	↓ 8.1	129140	1	→ Hash Join (cost=2.27..11526.17 rows=15939 width=19) (actual time=0.117..531.322 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.	186.357	186.357	↑ 1.0	255670	1	→ Seq Scan on gkclmtb (cost=0.00..6570.70 rows=255670 width=56) (actual time=0.025..186.357 rows=255670 loops=1)
8.	0.041	0.067	↑ 1.0	39	1	→ Hash (cost=1.39..1.39 rows=39 width=53) (actual time=0.067..0.067 rows=39 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 4kB
9.	0.026	0.026	↑ 1.0	39	1	→ Seq Scan on gkclstb (cost=0.00..1.39 rows=39 width=53) (actual time=0.003..0.026 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=11844.95..172783.48 rows=1 width=1025) (actual time=680.451..680.451 rows=1 loops=1)"
"  ->  Nested Loop Left Join  (cost=11844.95..172783.48 rows=1 width=1025) (actual time=680.449..680.449 rows=1 loops=1)"
"        ->  Hash Join  (cost=11844.95..172773.28 rows=1 width=1025) (actual time=680.430..680.430 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..99431.85 rows=125503 width=1029) (actual time=0.009..0.203 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=11526.17..11526.17 rows=15939 width=19) (actual time=677.300..677.300 rows=129140 loops=1)"
"                    Buckets: 2048  Batches: 8 (originally 1)  Memory Usage: 1025kB"
"                    ->  Hash Join  (cost=2.27..11526.17 rows=15939 width=19) (actual time=0.117..531.322 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.025..186.357 rows=255670 loops=1)"
"                          ->  Hash  (cost=1.39..1.39 rows=39 width=53) (actual time=0.067..0.067 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.026 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: 688.530 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	2	146.019 ms	21.5 %
Hash Join	2	347.825 ms	51.1 %
Index Scan	1	0.013 ms	0.0 %
Limit	1	0.002 ms	0.0 %
Nested Loop Left Join	1	0.006 ms	0.0 %
Seq Scan	3	186.586 ms	27.4 %

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	186.357 ms	27.4 %
Seq Scan	1	186.357 ms	100.0 %
gkclstb	1	0.026 ms	0.0 %
Seq Scan	1	0.026 ms	100.0 %
polygons	1	0.203 ms	0.0 %
Seq Scan	1	0.203 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: b8q

Colorize:

Columns visibility:

Per node type stats

Per table stats