explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OE6q

Settings
# exclusive inclusive rows x rows loops node
1. 0.171 16.395 ↓ 2.9 576 1

Sort (cost=2,367.42..2,367.92 rows=200 width=48) (actual time=16.359..16.395 rows=576 loops=1)

  • Sort Key: (first(_hyper_1_23_chunk.position_ts, _hyper_1_23_chunk.position_ts))
  • Sort Method: quicksort Memory: 70kB
2. 9.906 16.224 ↓ 2.9 576 1

GroupAggregate (cost=0.44..2,359.78 rows=200 width=48) (actual time=0.572..16.224 rows=576 loops=1)

  • Group Key: (time_bucket('00:05:00'::interval, _hyper_1_23_chunk.position_ts))
3. 1.327 6.318 ↓ 2.7 6,208 1

Result (cost=0.44..2,331.44 rows=2,334 width=32) (actual time=0.477..6.318 rows=6,208 loops=1)

4. 0.756 4.991 ↓ 2.7 6,208 1

Merge Append (cost=0.44..2,302.26 rows=2,334 width=24) (actual time=0.475..4.991 rows=6,208 loops=1)

  • Sort Key: (time_bucket('00:05:00'::interval, _hyper_1_23_chunk.position_ts))
5. 4.235 4.235 ↓ 2.7 6,208 1

Index Scan using _hyper_1_23_chunk_position_reorder_chunk_idx on _hyper_1_23_chunk (cost=0.43..2,278.91 rows=2,334 width=24) (actual time=0.474..4.235 rows=6,208 loops=1)

  • Index Cond: ((mean_id = 60713) AND (position_ts >= '2019-02-03 00:00:00'::timestamp without time zone) AND (position_ts <= '2019-02-05 00:00:00'::timestamp without time zone))
Planning time : 0.391 ms
Execution time : 20.088 ms