explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kZCe

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

Nested Loop (cost=4.29..13.59 rows=8 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on w02_kontrola_mko a (cost=0.00..1.01 rows=1 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on aw02_kontrola_foto2017 b (cost=4.29..12.57 rows=1 width=323) (actual rows= loops=)

  • Recheck Cond: (a.sdo_geom && geometria)
  • Filter: _st_intersects(a.sdo_geom, geometria)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_w02_kontrola_foto2017_geom (cost=0.00..4.29 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (a.sdo_geom && geometria)