explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Vpsw

Settings
# exclusive inclusive rows x rows loops node
1. 36.542 273.085 ↓ 1.0 80,859 1

Sort (cost=27,331.28..27,533.32 rows=80,818 width=30) (actual time=265.940..273.085 rows=80,859 loops=1)

  • Sort Key: _hyper_1_21_chunk."timestamp
  • Sort Method: quicksort Memory: 8690kB
2. 122.282 236.543 ↓ 1.0 80,859 1

Result (cost=0.42..20,743.64 rows=80,818 width=30) (actual time=0.064..236.543 rows=80,859 loops=1)

3. 10.250 114.261 ↓ 1.0 80,859 1

Append (cost=0.42..18,723.19 rows=80,818 width=1,557) (actual time=0.057..114.261 rows=80,859 loops=1)

4. 104.011 104.011 ↓ 1.0 80,859 1

Index Scan using _hyper_1_21_chunk_idx_vehicle_no on _hyper_1_21_chunk (cost=0.42..18,319.10 rows=80,818 width=1,557) (actual time=0.056..104.011 rows=80,859 loops=1)

  • Index Cond: (vehicle_no = 'B2202'::text)
  • Filter: (("timestamp" >= '2019-01-20 19:00:00-05'::timestamp with time zone) AND ("timestamp" < '2019-01-21 19:00:00-05'::timestamp with time zone))
Planning time : 0.699 ms
Execution time : 282.415 ms