explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gwQv

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=24.72..10,864,041.73 rows=3,378,903 width=102) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on geomtable (cost=0.00..23.60 rows=1,360 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on treebuffer10m simple (cost=24.72..1,774.55 rows=248 width=638) (actual rows= loops=)

  • Recheck Cond: (geomtable.polygeom && wkb_geometry)
  • Filter: _st_intersects(geomtable.polygeom, wkb_geometry)
  • -> Bitmap Index Scan on treebuffer10m_wkb_geometry_idx (cost=0.00..24.66 rows=745 width=0)" Index Cond: (geomtable.polygeom && wkb_geometry)