explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8fp8

Settings
# exclusive inclusive rows x rows loops node
1. 0.183 15.211 ↓ 48.0 576 1

Sort (cost=2,543.90..2,543.93 rows=12 width=40) (actual time=15.168..15.211 rows=576 loops=1)

  • Sort Key: q.position_ts
  • Sort Method: quicksort Memory: 70kB
2. 0.731 15.028 ↓ 48.0 576 1

Subquery Scan on q (cost=2,450.33..2,543.69 rows=12 width=40) (actual time=5.807..15.028 rows=576 loops=1)

  • Filter: (q.idx = 1)
  • Rows Removed by Filter: 5632
3. 8.007 14.297 ↓ 2.7 6,208 1

WindowAgg (cost=2,450.33..2,514.51 rows=2,334 width=56) (actual time=5.805..14.297 rows=6,208 loops=1)

4. 1.633 6.290 ↓ 2.7 6,208 1

Sort (cost=2,450.33..2,456.16 rows=2,334 width=32) (actual time=5.779..6.290 rows=6,208 loops=1)

  • Sort Key: (time_bucket('00:05:00'::interval, _hyper_1_23_chunk.position_ts)), _hyper_1_23_chunk.position_ts
  • Sort Method: quicksort Memory: 678kB
5. 1.559 4.657 ↓ 2.7 6,208 1

Result (cost=0.43..2,319.76 rows=2,334 width=32) (actual time=0.035..4.657 rows=6,208 loops=1)

6. 0.731 3.098 ↓ 2.7 6,208 1

Append (cost=0.43..2,290.58 rows=2,334 width=24) (actual time=0.034..3.098 rows=6,208 loops=1)

7. 2.367 2.367 ↓ 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.033..2.367 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.374 ms
Execution time : 15.291 ms