explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8Dt7

Settings
# exclusive inclusive rows x rows loops node
1. 19.765 126.173 ↓ 1.0 41,116 1

Sort (cost=13,875.09..13,977.69 rows=41,040 width=30) (actual time=122.841..126.173 rows=41,116 loops=1)

  • Sort Key: _hyper_1_12_chunk."timestamp
  • Sort Method: quicksort Memory: 4749kB
2. 69.686 106.408 ↓ 1.0 41,116 1

Result (cost=0.42..10,730.45 rows=41,040 width=30) (actual time=0.038..106.408 rows=41,116 loops=1)

3. 5.632 36.722 ↓ 1.0 41,116 1

Append (cost=0.42..9,704.45 rows=41,040 width=1,554) (actual time=0.030..36.722 rows=41,116 loops=1)

4. 31.090 31.090 ↓ 1.0 41,116 1

Index Scan using _hyper_1_12_chunk_idx_vehicle_no on _hyper_1_12_chunk (cost=0.42..9,499.25 rows=41,040 width=1,554) (actual time=0.029..31.090 rows=41,116 loops=1)

  • Index Cond: (vehicle_no = 'B2202'::text)
  • Filter: (("timestamp" >= '2019-01-10 19:00:00-05'::timestamp with time zone) AND ("timestamp" < '2019-01-11 19:00:00-05'::timestamp with time zone))
Planning time : 0.425 ms
Execution time : 130.466 ms