explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 7ZE

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.003 600.468 ↑ 1.0 1 1

Limit (cost=11,843.36..168,950.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=11,843.36..168,950.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=11,843.36..168,940.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 ↑ 1,147.8 104 1

Seq Scan on polygons (cost=0.00..98,605.25 rows=119,371 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 129,140 1

Hash (cost=11,525.64..11,525.64 rows=15,886 width=19) (actual time=597.320..597.320 rows=129,140 loops=1)

  • Buckets: 2048 Batches: 8 (originally 1) Memory Usage: 1025kB
6. 345.853 451.592 ↓ 8.1 129,140 1

Hash Join (cost=2.27..11,525.64 rows=15,886 width=19) (actual time=0.126..451.592 rows=129,140 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 255,670 1

Seq Scan on gkclmtb (cost=0.00..6,570.70 rows=255,670 width=56) (actual time=0.036..105.666 rows=255,670 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)