События (1000000)
1 000 000
событий в базе
23
полей в событии: 10 измерений + 11 метрик + id и время
55.5 МБ
на диске (сжато, 71.6 МБ без сжатия)
≈ 548.4 МБ
экспорт в JSON: 1 000 000 строк × 575 Б
— в 9.9× больше, чем на диске
| event_time | event_type | vehicle_id | driver_id | route_id | region | speed_kmh | fuel_consumption_l100 |
|---|---|---|---|---|---|---|---|
| 2026-07-16 03:04:04 | gps_ping | V-038 | D-25 | R-10 | latgale | 67.3 | 27 |
| 2026-07-16 03:03:59 | gps_ping | V-023 | D-11 | R-07 | riga | 28.7 | 35.8 |
| 2026-07-16 03:03:58 | speeding | V-022 | D-21 | R-12 | kurzeme | 16.8 | 27.9 |
| 2026-07-16 03:03:48 | idle | V-027 | D-08 | R-11 | vidzeme | 0 | 27.3 |
| 2026-07-16 03:03:48 | refuel | V-038 | D-18 | R-08 | latgale | 0 | 25.7 |
| 2026-07-16 03:03:45 | gps_ping | V-003 | D-21 | R-11 | vidzeme | 73.1 | 30.2 |
| 2026-07-16 03:03:42 | speeding | V-027 | D-05 | R-04 | vidzeme | 29.4 | 30.8 |
| 2026-07-16 03:03:42 | engine_fault | V-037 | D-26 | R-09 | riga | 45.1 | 38.7 |
| 2026-07-16 03:03:42 | refuel | V-023 | D-29 | R-15 | riga | 0 | 34 |
| 2026-07-16 03:03:40 | refuel | V-020 | D-23 | R-05 | riga | 0 | 30.1 |
| 2026-07-16 03:03:40 | gps_ping | V-010 | D-06 | R-04 | vidzeme | 28 | 22.4 |
| 2026-07-16 03:03:34 | idle | V-023 | D-18 | R-02 | kurzeme | 0 | 28.9 |
| 2026-07-16 03:03:33 | gps_ping | V-050 | D-26 | R-05 | riga | 63.4 | 26.2 |
| 2026-07-16 03:03:32 | trip_end | V-028 | D-24 | R-09 | riga | 71.6 | 32.6 |
| 2026-07-16 03:03:31 | gps_ping | V-016 | D-29 | R-11 | vidzeme | 55.2 | 28.1 |
| 2026-07-16 03:03:31 | engine_fault | V-008 | D-01 | R-15 | riga | 76.9 | 27.2 |
| 2026-07-16 03:03:29 | gps_ping | V-048 | D-08 | R-09 | riga | 40.9 | 32.8 |
| 2026-07-16 03:03:28 | engine_fault | V-005 | D-10 | R-05 | riga | 85.7 | 10.2 |
| 2026-07-16 03:03:28 | engine_fault | V-022 | D-06 | R-14 | latgale | 37.3 | 25.2 |
| 2026-07-16 03:03:27 | idle | V-049 | D-02 | R-12 | kurzeme | 0 | 38.9 |
| 2026-07-16 03:03:27 | gps_ping | V-005 | D-16 | R-08 | latgale | 86.1 | 13.5 |
| 2026-07-16 03:03:20 | gps_ping | V-037 | D-03 | R-05 | riga | 67.1 | 33.2 |
| 2026-07-16 03:03:19 | gps_ping | V-010 | D-01 | R-07 | riga | 60.8 | 30.9 |
| 2026-07-16 03:03:13 | gps_ping | V-010 | D-28 | R-11 | vidzeme | 91.8 | 34.5 |
| 2026-07-16 03:03:06 | gps_ping | V-038 | D-22 | R-06 | vidzeme | 46.7 | 31.3 |
| 2026-07-16 03:03:03 | harsh_braking | V-011 | D-25 | R-10 | latgale | 86.9 | 16.3 |
| 2026-07-16 03:02:59 | gps_ping | V-038 | D-21 | R-02 | kurzeme | 58.2 | 28.8 |
| 2026-07-16 03:02:56 | gps_ping | V-033 | D-19 | R-07 | riga | 34.5 | 26.4 |
| 2026-07-16 03:02:53 | engine_fault | V-034 | D-26 | R-02 | kurzeme | 33.9 | 27.6 |
| 2026-07-16 03:02:52 | trip_start | V-034 | D-24 | R-06 | vidzeme | 84.7 | 29 |
| 2026-07-16 03:02:49 | gps_ping | V-049 | D-17 | R-03 | kurzeme | 74.9 | 45.9 |
| 2026-07-16 03:02:48 | trip_end | V-036 | D-12 | R-01 | kurzeme | 60.8 | 39.3 |
| 2026-07-16 03:02:48 | trip_end | V-021 | D-02 | R-04 | vidzeme | 43.4 | 44.6 |
| 2026-07-16 03:02:47 | gps_ping | V-015 | D-07 | R-01 | kurzeme | 69.5 | 27.1 |
| 2026-07-16 03:02:47 | engine_fault | V-001 | D-21 | R-08 | latgale | 82.4 | 27.5 |
| 2026-07-16 03:02:46 | gps_ping | V-005 | D-28 | R-06 | vidzeme | 82.7 | 13.7 |
| 2026-07-16 03:02:37 | gps_ping | V-021 | D-12 | R-09 | riga | 22.8 | 29.5 |
| 2026-07-16 03:02:35 | gps_ping | V-036 | D-23 | R-06 | vidzeme | 84.7 | 23.1 |
| 2026-07-16 03:02:33 | refuel | V-010 | D-19 | R-02 | kurzeme | 0 | 25.7 |
| 2026-07-16 03:02:29 | gps_ping | V-015 | D-20 | R-13 | latgale | 85.1 | 26.9 |
| 2026-07-16 03:02:23 | idle | V-014 | D-20 | R-09 | riga | 0 | 32.6 |
| 2026-07-16 03:02:21 | trip_end | V-001 | D-20 | R-03 | kurzeme | 38.6 | 25.8 |
| 2026-07-16 03:02:20 | speeding | V-002 | D-13 | R-09 | riga | 86.3 | 32.9 |
| 2026-07-16 03:02:07 | engine_fault | V-016 | D-25 | R-01 | kurzeme | 86.7 | 34.6 |
| 2026-07-16 03:02:07 | gps_ping | V-024 | D-29 | R-04 | vidzeme | 47.6 | 12.8 |
| 2026-07-16 03:02:05 | trip_start | V-004 | D-11 | R-04 | vidzeme | 34.9 | 26.3 |
| 2026-07-16 03:02:02 | idle | V-050 | D-04 | R-15 | riga | 0 | 28.7 |
| 2026-07-16 03:01:53 | idle | V-034 | D-18 | R-15 | riga | 0 | 29.6 |
| 2026-07-16 03:01:50 | gps_ping | V-001 | D-08 | R-10 | latgale | 18.5 | 34.4 |
| 2026-07-16 03:01:48 | gps_ping | V-010 | D-17 | R-09 | riga | 50.5 | 31.7 |