explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ocP9

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 31,853.531 ↑ 1.0 1 1

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

  • Sort Key: parsel.ada
  • Sort Method: quicksort Memory: 25kB
2. 0.003 31,853.521 ↑ 1.0 1 1

Nested Loop (cost=22.70..2,259.54 rows=1 width=22) (actual time=27,415.172..31,853.521 rows=1 loops=1)

3. 0.003 31,853.461 ↑ 1.0 1 1

Nested Loop (cost=22.43..2,255.24 rows=1 width=26) (actual time=27,415.114..31,853.461 rows=1 loops=1)

4. 42.144 31,853.423 ↑ 1.0 1 1

Subquery Scan on pys_parsel_tadilat (cost=22.14..2,246.94 rows=1 width=12) (actual time=27,415.076..31,853.423 rows=1 loops=1)

  • Filter: (pys_parsel_tadilat.tadilat_id = 1)
  • Rows Removed by Filter: 91,672
5. 25,123.031 31,811.279 ↓ 10.8 91,673 1

Nested Loop (cost=22.14..2,141.25 rows=8,455 width=53) (actual time=0.655..31,811.279 rows=91,673 loops=1)

6. 20.475 20.496 ↓ 3.0 213 1

Bitmap Heap Scan on geotadilat t (cost=21.86..662.90 rows=70 width=615) (actual time=0.244..20.496 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,667.752 6,667.752 ↓ 430.0 430 213

Index Scan using gix_parsel on parsel p (cost=0.28..17.49 rows=1 width=251) (actual time=0.226..31.304 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.035 0.035 ↑ 1.0 1 1

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

  • Index Cond: (objectid = pys_parsel_tadilat.parsel_id)
10. 0.057 0.057 ↑ 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.056..0.057 rows=1 loops=1)

  • Index Cond: (objectid = 1)
  • Heap Fetches: 0
Planning time : 1.455 ms
Execution time : 31,853.610 ms