explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AidA : Optimization for: plan #osjK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 0.011 ↓ 0.0 0 1

Update on sensor_value (cost=0.42..64.52 rows=15 width=70) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.009 0.009 ↓ 0.0 0 1

Index Scan using sensor_value_uk2 on sensor_value (cost=0.42..64.52 rows=15 width=70) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((road_station_id = '371'::numeric) AND (road_station_sensor_id = '22'::numeric))
Planning time : 0.156 ms
Execution time : 0.047 ms