explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mjuo

Settings
# exclusive inclusive rows x rows loops node
1. 53.863 100,575.670 ↑ 1.4 41,116 1

Sort (cost=20,116.69..20,263.07 rows=58,552 width=30) (actual time=100,571.347..100,575.670 rows=41,116 loops=1)

  • Sort Key: _hyper_1_12_chunk."timestamp
  • Sort Method: quicksort Memory: 4749kB
2. 145.746 100,521.807 ↑ 1.4 41,116 1

Result (cost=0.42..15,480.12 rows=58,552 width=30) (actual time=16.047..100,521.807 rows=41,116 loops=1)

3. 12.488 100,376.061 ↑ 1.4 41,116 1

Append (cost=0.42..14,016.32 rows=58,552 width=1,563) (actual time=16.036..100,376.061 rows=41,116 loops=1)

4. 100,363.573 100,363.573 ↑ 1.4 41,116 1

Index Scan using _hyper_1_12_chunk_idx_vehicle_no on _hyper_1_12_chunk (cost=0.42..13,723.56 rows=58,552 width=1,563) (actual time=16.035..100,363.573 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.356 ms
Execution time : 100,581.317 ms