# | 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)
|
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)
|
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)
|
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)
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
|
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)
|
Planning time | : | 18.619 ms |
---|---|---|
Execution time | : | 387.696 ms |