#	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

Limit  (cost=0.42..87897.63 rows=100000 width=30) (actual time=0.517..380.137 rows=100000 loops=1)
  ->  Custom Scan (ChunkAppend) on vehicle_telemetry  (cost=0.42..94943.47 rows=108016 width=30) (actual time=0.515..368.438 rows=100000 loops=1)
        Order: vehicle_telemetry."timestamp"
        ->  Index Scan using "1_1_vehicle_telemetry_pkey" on _hyper_1_1_chunk  (cost=0.42..53024.12 rows=73303 width=1574) (actual time=0.498..97.192 rows=66776 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))
        ->  Index Scan using "2_2_vehicle_telemetry_pkey" on _hyper_1_2_chunk  (cost=0.42..40299.11 rows=34713 width=1561) (actual time=25.848..89.589 rows=28227 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))
        ->  Index Scan using "3_3_vehicle_telemetry_pkey" on _hyper_1_3_chunk  (cost=0.42..99289.23 rows=128929 width=1578) (actual time=4.396..12.068 rows=4997 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))
        ->  Index Scan using "4_4_vehicle_telemetry_pkey" on _hyper_1_4_chunk  (cost=0.42..102413.73 rows=149745 width=1588) (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))
        ->  Index Scan using "6_6_vehicle_telemetry_pkey" on _hyper_1_6_chunk  (cost=0.42..104522.85 rows=115941 width=1568) (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))
        ->  Index Scan using "7_7_vehicle_telemetry_pkey" on _hyper_1_7_chunk  (cost=0.42..83081.25 rows=89938 width=1571) (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))
        ->  Index Scan using "8_8_vehicle_telemetry_pkey" on _hyper_1_8_chunk  (cost=0.42..74466.72 rows=84866 width=1564) (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))
        ->  Index Scan using "9_9_vehicle_telemetry_pkey" on _hyper_1_9_chunk  (cost=0.42..74433.26 rows=103508 width=1586) (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))
        ->  Index Scan using "10_10_vehicle_telemetry_pkey" on _hyper_1_10_chunk  (cost=0.42..46087.37 rows=54470 width=1584) (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))
        ->  Index Scan using "11_11_vehicle_telemetry_pkey" on _hyper_1_11_chunk  (cost=0.42..65477.09 rows=75725 width=1586) (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))
        ->  Index Scan using "12_12_vehicle_telemetry_pkey" on _hyper_1_12_chunk  (cost=0.42..40661.54 rows=37482 width=1563) (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))
        ->  Index Scan using "13_13_vehicle_telemetry_pkey" on _hyper_1_13_chunk  (cost=0.42..22772.42 rows=14608 width=1560) (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))
        ->  Index Scan using "14_14_vehicle_telemetry_pkey" on _hyper_1_14_chunk  (cost=0.42..66558.08 rows=63508 width=1578) (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))
        ->  Index Scan using "15_15_vehicle_telemetry_pkey" on _hyper_1_15_chunk  (cost=0.42..89281.07 rows=98606 width=1571) (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))
        ->  Index Scan using "16_16_vehicle_telemetry_pkey" on _hyper_1_16_chunk  (cost=0.42..33226.39 rows=23585 width=1563) (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))
        ->  Index Scan using "17_17_vehicle_telemetry_pkey" on _hyper_1_17_chunk  (cost=0.42..51998.82 rows=46332 width=1578) (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))
        ->  Index Scan using "18_18_vehicle_telemetry_pkey" on _hyper_1_18_chunk  (cost=0.42..79080.03 rows=97549 width=1561) (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))
        ->  Index Scan using "19_19_vehicle_telemetry_pkey" on _hyper_1_19_chunk  (cost=0.42..107130.91 rows=131904 width=1574) (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))
        ->  Index Scan using "20_20_vehicle_telemetry_pkey" on _hyper_1_20_chunk  (cost=0.42..46590.14 rows=54946 width=1570) (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))
        ->  Index Scan using "351_351_vehicle_telemetry_pkey" on _hyper_1_351_chunk  (cost=0.42..7375.47 rows=1 width=1577) (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))
        ->  Index Scan using "21_21_vehicle_telemetry_pkey" on _hyper_1_21_chunk  (cost=0.42..25384.46 rows=17546 width=1567) (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))
        ->  Index Scan using "22_22_vehicle_telemetry_pkey" on _hyper_1_22_chunk  (cost=0.42..52430.97 rows=48935 width=1572) (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))
        ->  Index Scan using "23_23_vehicle_telemetry_pkey" on _hyper_1_23_chunk  (cost=0.42..70610.00 rows=75673 width=1579) (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))
        ->  Index Scan using "24_24_vehicle_telemetry_pkey" on _hyper_1_24_chunk  (cost=0.42..72107.50 rows=76000 width=1567) (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))
        ->  Index Scan using "25_25_vehicle_telemetry_pkey" on _hyper_1_25_chunk  (cost=0.42..72422.63 rows=86696 width=1570) (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))
        ->  Index Scan using "26_26_vehicle_telemetry_pkey" on _hyper_1_26_chunk  (cost=0.42..63430.37 rows=62857 width=1556) (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))
        ->  Index Scan using "27_27_vehicle_telemetry_pkey" on _hyper_1_27_chunk  (cost=0.42..67440.23 rows=72796 width=1570) (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))
        ->  Index Scan using "28_28_vehicle_telemetry_pkey" on _hyper_1_28_chunk  (cost=0.42..66274.27 rows=68755 width=1577) (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))
        ->  Index Scan using "29_29_vehicle_telemetry_pkey" on _hyper_1_29_chunk  (cost=0.42..88768.05 rows=101924 width=1558) (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))
        ->  Index Scan using "30_30_vehicle_telemetry_pkey" on _hyper_1_30_chunk  (cost=0.42..86861.85 rows=104092 width=1566) (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))
        ->  Index Scan using "5_5_vehicle_telemetry_pkey" on _hyper_1_5_chunk  (cost=0.42..55430.60 rows=65825 width=1540) (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))
        ->  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=1549) (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

Per node type stats

node type	count	sum of times	% of query
Custom Scan (ChunkAppend) on vehicle_telemetry	1	169.589 ms	44.6 %
Index Scan	31	198.849 ms	52.3 %
Index Scan Backward	1	0.000 ms	0.0 %
Limit	1	11.699 ms	3.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
_hyper_1_10_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_11_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_12_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_13_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_14_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_15_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_16_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_17_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_18_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_19_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_1_chunk	1	97.192 ms	25.6 %
Index Scan	1	97.192 ms	100.0 %
_hyper_1_20_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_21_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_22_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_23_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_24_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_25_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_26_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_27_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_28_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_29_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_2_chunk	1	89.589 ms	23.6 %
Index Scan	1	89.589 ms	100.0 %
_hyper_1_30_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_31_chunk	1	0.000 ms	0.0 %
Index Scan Backward	1	0.000 ms	0.0 %
_hyper_1_351_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_3_chunk	1	12.068 ms	3.2 %
Index Scan	1	12.068 ms	100.0 %
_hyper_1_4_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_5_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_6_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_7_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_8_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %
_hyper_1_9_chunk	1	0.000 ms	0.0 %
Index Scan	1	0.000 ms	0.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EFuu

Color mode:

Visible columns:

Per node type stats

Per table stats