explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ca01

Settings
# exclusive inclusive rows x rows loops node
1. 10,369.478 10,369.478 ↓ 1.4 7,151,241 1

Index Only Scan using measurement_v2_measurement_start_time_idx on measurement (cost=0.57..3,248,833.88 rows=5,053,726 width=8) (actual time=0.139..10,369.478 rows=7,151,241 loops=1)

  • Index Cond: (measurement_start_time >= '2019-09-09 00:00:00'::timestamp without time zone)
  • Heap Fetches: 7,151,241
Planning time : 0.172 ms
Execution time : 15,951.671 ms