explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nnT

Settings
# exclusive inclusive rows x rows loops node
1. 33.094 606.524 ↓ 34,096.0 34,096 1

Hash Join (cost=45.84..17,028.83 rows=1 width=272) (actual time=423.098..606.524 rows=34,096 loops=1)

  • Hash Cond: (((bo.ada)::text = (p.ada)::text) AND ((bo.parsel)::text = (p.parsel)::text) AND ((bo.mahalle)::integer = m.uavt_kod))
2. 150.381 150.381 ↓ 1.0 36,972 1

Seq Scan on mis_borc bo (cost=0.00..16,480.61 rows=36,536 width=13) (actual time=0.023..150.381 rows=36,972 loops=1)

  • Filter: ((gecikenborc IS NOT NULL) AND ((gecikenborc)::text <> '0'::text))
  • Rows Removed by Filter: 443557
3. 7.548 423.049 ↓ 7,469.0 7,469 1

Hash (cost=45.82..45.82 rows=1 width=270) (actual time=423.049..423.049 rows=7,469 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2024kB
4. 4.144 415.501 ↓ 7,471.0 7,471 1

Nested Loop (cost=0.28..45.82 rows=1 width=270) (actual time=0.844..415.501 rows=7,471 loops=1)

5. 0.012 0.012 ↑ 1.0 5 1

Seq Scan on geomahalle m (cost=0.00..3.05 rows=5 width=36) (actual time=0.004..0.012 rows=5 loops=1)

6. 411.345 411.345 ↓ 1,494.0 1,494 5

Index Scan using gix1450084132 on parsel p (cost=0.28..8.54 rows=1 width=266) (actual time=1.324..82.269 rows=1,494 loops=5)

  • Index Cond: ((m.poly && poly) AND (m.poly && poly))
  • Filter: (geo_durum AND _st_intersects(m.poly, poly))
  • Rows Removed by Filter: 3475