explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DpA4

Settings
# exclusive inclusive rows x rows loops node
1. 13,552.585 13,625.606 ↑ 1.5 32 1

Nested Loop (cost=0.00..40,014.93 rows=49 width=25) (actual time=1,273.812..13,625.606 rows=32 loops=1)

  • Join Filter: ((st_buffer(haberlesme_hat_yeni.poly, '1'::double precision) && g.poly) AND _st_intersects(st_buffer(haberlesme_hat_yeni.poly, '1'::double precision), g.poly))
  • Rows Removed by Join Filter: 146918
2. 5.424 5.424 ↑ 1.0 2,939 1

Seq Scan on geoyol g (cost=0.00..321.12 rows=2,939 width=243) (actual time=0.018..5.424 rows=2,939 loops=1)

  • Filter: (geo_durum IS TRUE)
  • Rows Removed by Filter: 73
3. 67.437 67.597 ↑ 1.0 50 2,939

Materialize (cost=0.00..4.81 rows=50 width=108) (actual time=0.000..0.023 rows=50 loops=2,939)

4. 0.022 0.160 ↑ 1.0 50 1

Limit (cost=0.00..4.06 rows=50 width=108) (actual time=0.010..0.160 rows=50 loops=1)

5. 0.138 0.138 ↑ 449.8 50 1

Seq Scan on haberlesme_hat_yeni (cost=0.00..1,827.88 rows=22,488 width=108) (actual time=0.009..0.138 rows=50 loops=1)

Planning time : 0.325 ms