explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TR7u

Settings

Optimization(s) for this plan:

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

Update on sensor_value sv (cost=0.84..8,902.60 rows=540 width=76) (actual time=0.023..0.023 rows=0 loops=1)

2. 0.001 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.84..8,902.60 rows=540 width=76) (actual time=0.023..0.023 rows=0 loops=1)

3. 0.013 0.013 ↑ 1.0 1 1

Index Scan using rs_sensor_rs_type_fk_i on road_station_sensor sensor (cost=0.27..8.29 rows=1 width=11) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (((road_station_type)::text = 'TMS_STATION'::text) AND (lotju_id = '85'::numeric) AND (publishable = true))
  • Filter: publishable
4. 0.009 0.009 ↓ 0.0 0 1

Index Scan using sensor_value_uk1 on sensor_value sv (cost=0.56..8,860.02 rows=2,348 width=22) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((road_station_sensor_id = sensor.id) AND (road_station_id = '371'::numeric))