explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bhC8

Settings

Optimization path:

Optimization(s) for this plan:

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

Nested Loop (cost=0.43..1,139.45 rows=184 width=159) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Values Scan on "*VALUES*" (cost=0.00..1.69 rows=135 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using res_geom_ares_id_idx on reservation_geometries_indices g (cost=0.43..8.42 rows=1 width=155) (actual rows= loops=)

  • Index Cond: (airspace_reservation_id = "*VALUES*".column1)