explain.depesz.com

A tool for finding a real cause for slow queries.

Result: b8q

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

Limit (cost=11,844.95..172,783.48 rows=1 width=1,025) (actual time=680.451..680.451 rows=1 loops=1)

2. 0.006 680.449 ↑ 1.0 1 1

Nested Loop Left Join (cost=11,844.95..172,783.48 rows=1 width=1,025) (actual time=680.449..680.449 rows=1 loops=1)

3. 2.927 680.430 ↑ 1.0 1 1

Hash Join (cost=11,844.95..172,773.28 rows=1 width=1,025) (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 ↑ 1,206.8 104 1

Seq Scan on polygons (cost=0.00..99,431.85 rows=125,503 width=1,029) (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 129,140 1

Hash (cost=11,526.17..11,526.17 rows=15,939 width=19) (actual time=677.300..677.300 rows=129,140 loops=1)

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

Hash Join (cost=2.27..11,526.17 rows=15,939 width=19) (actual time=0.117..531.322 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. 186.357 186.357 ↑ 1.0 255,670 1

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