explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vU1G

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=0.28..13.83 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

Index Scan using idx_w02_kontrola_foto2017_geom on aw02_kontrola_foto2017 b (cost=0.28..12.81 rows=1 width=323) (actual rows= loops=)

  • Index Cond: (a.sdo_geom && geometria)
  • Filter: _st_intersects(a.sdo_geom, geometria)