explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AqC1

Settings
# exclusive inclusive rows x rows loops node
1. 371.090 828.998 ↓ 423,801.0 423,801 1

Hash Join (cost=45.84..21,932.42 rows=1 width=272) (actual time=390.917..828.998 rows=423,801 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. 67.035 67.035 ↑ 1.0 480,529 1

Seq Scan on mis_borc bo (cost=0.00..15,279.29 rows=480,529 width=13) (actual time=0.017..67.035 rows=480,529 loops=1)

3. 7.432 390.873 ↓ 7,469.0 7,469 1

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

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

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

5. 0.013 0.013 ↑ 1.0 5 1

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

6. 379.785 379.785 ↓ 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.169..75.957 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