explain.depesz.com

PostgreSQL's explain analyze made readable

Result: myEs

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 32,139.516 ↑ 1.0 1 1

Nested Loop (cost=22.70..2,259.54 rows=1 width=22) (actual time=27,575.412..32,139.516 rows=1 loops=1)

2. 0.004 32,139.506 ↑ 1.0 1 1

Nested Loop (cost=22.43..2,255.24 rows=1 width=26) (actual time=27,575.402..32,139.506 rows=1 loops=1)

3. 43.116 32,139.486 ↑ 1.0 1 1

Subquery Scan on pys_parsel_tadilat (cost=22.14..2,246.94 rows=1 width=12) (actual time=27,575.383..32,139.486 rows=1 loops=1)

  • Filter: (pys_parsel_tadilat.tadilat_id = 1)
  • Rows Removed by Filter: 91,672
4. 25,335.136 32,096.370 ↓ 10.8 91,673 1

Nested Loop (cost=22.14..2,141.25 rows=8,455 width=53) (actual time=0.681..32,096.370 rows=91,673 loops=1)

5. 20.400 20.423 ↓ 3.0 213 1

Bitmap Heap Scan on geotadilat t (cost=21.86..662.90 rows=70 width=615) (actual time=0.283..20.423 rows=213 loops=1)

  • Filter: ((geo_durum IS TRUE) AND (((m_status)::text <> 'DELETE'::text) OR ((m_status)::text IS NULL)) AND st_isvalid(poly))
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=73
6. 0.023 0.023 ↓ 1.2 252 1

Bitmap Index Scan on idx_geotadilat_geo_durum (cost=0.00..21.85 rows=210 width=0) (actual time=0.023..0.023 rows=252 loops=1)

  • Index Cond: (geo_durum = true)
7. 6,740.811 6,740.811 ↓ 430.0 430 213

Index Scan using gix_parsel on parsel p (cost=0.28..17.49 rows=1 width=251) (actual time=0.231..31.647 rows=430 loops=213)

  • Index Cond: (poly && t.poly)
  • Filter: ((geo_durum IS TRUE) AND CASE WHEN (t.konum_id = 1) THEN ((t.poly ~ poly) AND _st_contains(t.poly, poly) AND (t.poly && poly)) WHEN (t.konum_id = 2) THEN ((t.poly && poly) AND _st_intersects(t.poly, poly) AND (t.poly && poly) AND (st_area(st_intersection(t.poly, poly)) > '0.5'::double precision)) ELSE NULL::boolean END AND st_isvalid(poly))
  • Rows Removed by Filter: 305
8. 0.016 0.016 ↑ 1.0 1 1

Index Scan using idx_parsel_objectid on parsel (cost=0.29..8.30 rows=1 width=18) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (objectid = pys_parsel_tadilat.parsel_id)
9. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using geotadilat_objectid_uniq on geotadilat (cost=0.27..4.29 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (objectid = 1)
  • Heap Fetches: 0
Planning time : 1.420 ms
Execution time : 32,139.591 ms