explain.depesz.com

PostgreSQL's explain analyze made readable

Result: osjK

Settings

Optimization(s) for this plan:

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

Update on sensor_value (cost=0.56..12,368.49 rows=3,265 width=70) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.011 0.011 ↓ 0.0 0 1

Index Scan using sensor_value_uk1 on sensor_value (cost=0.56..12,368.49 rows=3,265 width=70) (actual time=0.011..0.011 rows=0 loops=1)

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