explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uzXe

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 32,531.532 ↑ 1.0 1 1

Sort (cost=2,259.55..2,259.56 rows=1 width=22) (actual time=32,531.532..32,531.532 rows=1 loops=1)

  • Sort Key: parsel.ada
  • Sort Method: quicksort Memory: 25kB
2. 0.001 32,531.523 ↑ 1.0 1 1

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

3. 0.005 32,531.514 ↑ 1.0 1 1

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

4. 44.175 32,531.493 ↑ 1.0 1 1

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

  • Filter: (pys_parsel_tadilat.tadilat_id = 1)
  • Rows Removed by Filter: 91,672
5. 25,545.254 32,487.318 ↓ 10.8 91,673 1

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

6. 20.821 20.842 ↓ 3.0 213 1

Bitmap Heap Scan on geotadilat t (cost=21.86..662.90 rows=70 width=615) (actual time=0.264..20.842 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
7. 0.021 0.021 ↓ 1.2 252 1

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

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

Index Scan using gix_parsel on parsel p (cost=0.28..17.49 rows=1 width=251) (actual time=0.258..32.494 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
9. 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)
10. 0.008 0.008 ↑ 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.007..0.008 rows=1 loops=1)

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