explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CeGE

Settings
# exclusive inclusive rows x rows loops node
1. 420.564 13,824.575 ↓ 0.0 0 1

Update on measurement (cost=0.43..17,372.48 rows=6,612 width=44) (actual time=13,824.572..13,824.575 rows=0 loops=1)

  • Update on measurement
  • Update on _hyper_3_127_chunk
2. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.43..2.65 rows=1 width=44) (actual time=0.003..0.004 rows=0 loops=1)

3. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on measurement (cost=0.00..0.00 rows=1 width=34) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (("time" >= '2020-10-16 00:00:00'::timestamp without time zone) AND ("time" <= '2020-10-16 00:01:00'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using measurement_label_pkey on measurement_label (cost=0.43..2.65 rows=1 width=14) (never executed)

  • Index Cond: (id = measurement.label_id)
5. 2.996 13,404.007 ↑ 1.3 5,268 1

Nested Loop (cost=0.87..17,369.83 rows=6,611 width=44) (actual time=0.026..13,404.007 rows=5,268 loops=1)

6. 720.935 720.935 ↑ 1.3 5,268 1

Index Scan using _hyper_3_127_chunk_measurement_time_idx on _hyper_3_127_chunk (cost=0.43..571.15 rows=6,611 width=34) (actual time=0.018..720.935 rows=5,268 loops=1)

  • Index Cond: (("time" >= '2020-10-16 00:00:00'::timestamp without time zone) AND ("time" <= '2020-10-16 00:01:00'::timestamp without time zone))
7. 12,680.076 12,680.076 ↑ 1.0 1 5,268

Index Scan using measurement_label_pkey on measurement_label (cost=0.43..2.54 rows=1 width=14) (actual time=2.407..2.407 rows=1 loops=5,268)

  • Index Cond: (id = _hyper_3_127_chunk.label_id)
Planning time : 1.152 ms
Execution time : 13,824.618 ms