explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lLPS

Settings
# exclusive inclusive rows x rows loops node
1. 808,592.985 812,492.228 ↓ 0.0 0 1

Delete on sensor_values_2017q2 (cost=0.57..165,659.48 rows=193,168 width=6) (actual time=812,492.228..812,492.228 rows=0 loops=1)

  • Buffers: shared hit=407667 dirtied=163171
2. 3,899.243 3,899.243 ↓ 1.1 205,530 1

Index Scan using sensor_values_2017q2_sensor_id_timestamp_value_index on sensor_values_2017q2 (cost=0.57..165,659.48 rows=193,168 width=6) (actual time=0.107..3,899.243 rows=205,530 loops=1)

  • Index Cond: (sensor_id = 597795)
  • Buffers: shared hit=202137 dirtied=163157
Planning time : 0.342 ms
Execution time : 812,510.208 ms