explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EFuu

Settings
# exclusive inclusive rows x rows loops node
1. 11.699 380.137 ↑ 1.0 100,000 1

Limit (cost=0.42..87,897.63 rows=100,000 width=30) (actual time=0.517..380.137 rows=100,000 loops=1)

2. 169.589 368.438 ↑ 1.1 100,000 1

Custom Scan (ChunkAppend) on vehicle_telemetry (cost=0.42..94,943.47 rows=108,016 width=30) (actual time=0.515..368.438 rows=100,000 loops=1)

  • Order: vehicle_telemetry."timestamp
3. 97.192 97.192 ↑ 1.1 66,776 1

Index Scan using "1_1_vehicle_telemetry_pkey" on _hyper_1_1_chunk (cost=0.42..53,024.12 rows=73,303 width=1,574) (actual time=0.498..97.192 rows=66,776 loops=1)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
4. 89.589 89.589 ↑ 1.2 28,227 1

Index Scan using "2_2_vehicle_telemetry_pkey" on _hyper_1_2_chunk (cost=0.42..40,299.11 rows=34,713 width=1,561) (actual time=25.848..89.589 rows=28,227 loops=1)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
5. 12.068 12.068 ↑ 25.8 4,997 1

Index Scan using "3_3_vehicle_telemetry_pkey" on _hyper_1_3_chunk (cost=0.42..99,289.23 rows=128,929 width=1,578) (actual time=4.396..12.068 rows=4,997 loops=1)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
6. 0.000 0.000 ↓ 0.0 0

Index Scan using "4_4_vehicle_telemetry_pkey" on _hyper_1_4_chunk (cost=0.42..102,413.73 rows=149,745 width=1,588) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using "6_6_vehicle_telemetry_pkey" on _hyper_1_6_chunk (cost=0.42..104,522.85 rows=115,941 width=1,568) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
8. 0.000 0.000 ↓ 0.0 0

Index Scan using "7_7_vehicle_telemetry_pkey" on _hyper_1_7_chunk (cost=0.42..83,081.25 rows=89,938 width=1,571) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using "8_8_vehicle_telemetry_pkey" on _hyper_1_8_chunk (cost=0.42..74,466.72 rows=84,866 width=1,564) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
10. 0.000 0.000 ↓ 0.0 0

Index Scan using "9_9_vehicle_telemetry_pkey" on _hyper_1_9_chunk (cost=0.42..74,433.26 rows=103,508 width=1,586) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using "10_10_vehicle_telemetry_pkey" on _hyper_1_10_chunk (cost=0.42..46,087.37 rows=54,470 width=1,584) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using "11_11_vehicle_telemetry_pkey" on _hyper_1_11_chunk (cost=0.42..65,477.09 rows=75,725 width=1,586) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using "12_12_vehicle_telemetry_pkey" on _hyper_1_12_chunk (cost=0.42..40,661.54 rows=37,482 width=1,563) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
14. 0.000 0.000 ↓ 0.0 0

Index Scan using "13_13_vehicle_telemetry_pkey" on _hyper_1_13_chunk (cost=0.42..22,772.42 rows=14,608 width=1,560) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
15. 0.000 0.000 ↓ 0.0 0

Index Scan using "14_14_vehicle_telemetry_pkey" on _hyper_1_14_chunk (cost=0.42..66,558.08 rows=63,508 width=1,578) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using "15_15_vehicle_telemetry_pkey" on _hyper_1_15_chunk (cost=0.42..89,281.07 rows=98,606 width=1,571) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
17. 0.000 0.000 ↓ 0.0 0

Index Scan using "16_16_vehicle_telemetry_pkey" on _hyper_1_16_chunk (cost=0.42..33,226.39 rows=23,585 width=1,563) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using "17_17_vehicle_telemetry_pkey" on _hyper_1_17_chunk (cost=0.42..51,998.82 rows=46,332 width=1,578) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using "18_18_vehicle_telemetry_pkey" on _hyper_1_18_chunk (cost=0.42..79,080.03 rows=97,549 width=1,561) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
20. 0.000 0.000 ↓ 0.0 0

Index Scan using "19_19_vehicle_telemetry_pkey" on _hyper_1_19_chunk (cost=0.42..107,130.91 rows=131,904 width=1,574) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
21. 0.000 0.000 ↓ 0.0 0

Index Scan using "20_20_vehicle_telemetry_pkey" on _hyper_1_20_chunk (cost=0.42..46,590.14 rows=54,946 width=1,570) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
22. 0.000 0.000 ↓ 0.0 0

Index Scan using "351_351_vehicle_telemetry_pkey" on _hyper_1_351_chunk (cost=0.42..7,375.47 rows=1 width=1,577) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
23. 0.000 0.000 ↓ 0.0 0

Index Scan using "21_21_vehicle_telemetry_pkey" on _hyper_1_21_chunk (cost=0.42..25,384.46 rows=17,546 width=1,567) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
24. 0.000 0.000 ↓ 0.0 0

Index Scan using "22_22_vehicle_telemetry_pkey" on _hyper_1_22_chunk (cost=0.42..52,430.97 rows=48,935 width=1,572) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
25. 0.000 0.000 ↓ 0.0 0

Index Scan using "23_23_vehicle_telemetry_pkey" on _hyper_1_23_chunk (cost=0.42..70,610.00 rows=75,673 width=1,579) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using "24_24_vehicle_telemetry_pkey" on _hyper_1_24_chunk (cost=0.42..72,107.50 rows=76,000 width=1,567) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
27. 0.000 0.000 ↓ 0.0 0

Index Scan using "25_25_vehicle_telemetry_pkey" on _hyper_1_25_chunk (cost=0.42..72,422.63 rows=86,696 width=1,570) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
28. 0.000 0.000 ↓ 0.0 0

Index Scan using "26_26_vehicle_telemetry_pkey" on _hyper_1_26_chunk (cost=0.42..63,430.37 rows=62,857 width=1,556) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
29. 0.000 0.000 ↓ 0.0 0

Index Scan using "27_27_vehicle_telemetry_pkey" on _hyper_1_27_chunk (cost=0.42..67,440.23 rows=72,796 width=1,570) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
30. 0.000 0.000 ↓ 0.0 0

Index Scan using "28_28_vehicle_telemetry_pkey" on _hyper_1_28_chunk (cost=0.42..66,274.27 rows=68,755 width=1,577) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
31. 0.000 0.000 ↓ 0.0 0

Index Scan using "29_29_vehicle_telemetry_pkey" on _hyper_1_29_chunk (cost=0.42..88,768.05 rows=101,924 width=1,558) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using "30_30_vehicle_telemetry_pkey" on _hyper_1_30_chunk (cost=0.42..86,861.85 rows=104,092 width=1,566) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
33. 0.000 0.000 ↓ 0.0 0

Index Scan using "5_5_vehicle_telemetry_pkey" on _hyper_1_5_chunk (cost=0.42..55,430.60 rows=65,825 width=1,540) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone) AND (vehicle_no = 'B2201'::text))
34. 0.000 0.000 ↓ 0.0 0

Index Scan Backward using _hyper_1_31_chunk_vehicle_telemetry_timestamp_idx on _hyper_1_31_chunk (cost=0.42..2.65 rows=1 width=1,549) (never executed)

  • Index Cond: (("timestamp" > '2018-12-31 19:00:00-05'::timestamp with time zone) AND ("timestamp" <= '2019-01-31 19:00:00-05'::timestamp with time zone))
  • Filter: (vehicle_no = 'B2201'::text)
Planning time : 18.619 ms
Execution time : 387.696 ms