События (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:12:52 | gps_ping | V-008 | D-17 | R-05 | riga | 57.3 | 28.7 |
| 2026-07-16 03:12:52 | gps_ping | V-012 | D-04 | R-08 | latgale | 48.2 | 26.9 |
| 2026-07-16 03:12:48 | gps_ping | V-026 | D-07 | R-11 | vidzeme | 32.9 | 13.4 |
| 2026-07-16 03:12:48 | engine_fault | V-026 | D-01 | R-08 | latgale | 51.8 | 13 |
| 2026-07-16 03:12:47 | refuel | V-012 | D-13 | R-10 | latgale | 0 | 29.6 |
| 2026-07-16 03:12:43 | gps_ping | V-022 | D-20 | R-11 | vidzeme | 94.6 | 29.1 |
| 2026-07-16 03:12:42 | refuel | V-032 | D-24 | R-10 | latgale | 0 | 17 |
| 2026-07-16 03:12:41 | engine_fault | V-018 | D-18 | R-04 | vidzeme | 21.3 | 13.9 |
| 2026-07-16 03:12:36 | gps_ping | V-015 | D-01 | R-02 | kurzeme | 58.5 | 28.5 |
| 2026-07-16 03:12:34 | gps_ping | V-043 | D-25 | R-02 | kurzeme | 56.5 | 28.6 |
| 2026-07-16 03:12:30 | gps_ping | V-021 | D-06 | R-09 | riga | 28.1 | 32.4 |
| 2026-07-16 03:12:29 | gps_ping | V-026 | D-06 | R-13 | latgale | 48.7 | 13 |
| 2026-07-16 03:12:26 | gps_ping | V-021 | D-02 | R-15 | riga | 90.7 | 35.8 |
| 2026-07-16 03:12:25 | trip_end | V-043 | D-17 | R-14 | latgale | 94.7 | 20.1 |
| 2026-07-16 03:12:24 | trip_end | V-011 | D-02 | R-02 | kurzeme | 72.1 | 13.1 |
| 2026-07-16 03:12:22 | gps_ping | V-012 | D-16 | R-02 | kurzeme | 81.6 | 30.5 |
| 2026-07-16 03:12:21 | speeding | V-005 | D-14 | R-15 | riga | 41.5 | 16.7 |
| 2026-07-16 03:12:18 | gps_ping | V-006 | D-10 | R-07 | riga | 62.3 | 27.9 |
| 2026-07-16 03:12:14 | gps_ping | V-005 | D-09 | R-08 | latgale | 74.8 | 15.4 |
| 2026-07-16 03:12:09 | trip_end | V-008 | D-04 | R-15 | riga | 50.1 | 32.8 |
| 2026-07-16 03:12:06 | trip_end | V-044 | D-12 | R-08 | latgale | 70.3 | 27.9 |
| 2026-07-16 03:12:05 | trip_end | V-003 | D-08 | R-06 | vidzeme | 69.5 | 30.9 |
| 2026-07-16 03:12:03 | gps_ping | V-002 | D-25 | R-15 | riga | 43 | 33.9 |
| 2026-07-16 03:12:01 | idle | V-001 | D-14 | R-13 | latgale | 0 | 29 |
| 2026-07-16 03:12:01 | gps_ping | V-042 | D-25 | R-05 | riga | 12.3 | 28 |
| 2026-07-16 03:12:00 | speeding | V-018 | D-26 | R-07 | riga | 19.9 | 15.9 |
| 2026-07-16 03:11:58 | gps_ping | V-013 | D-24 | R-06 | vidzeme | 70.2 | 9.8 |
| 2026-07-16 03:11:54 | gps_ping | V-035 | D-21 | R-11 | vidzeme | 53.1 | 32.3 |
| 2026-07-16 03:11:50 | gps_ping | V-011 | D-11 | R-09 | riga | 48.5 | 13.4 |
| 2026-07-16 03:11:49 | gps_ping | V-010 | D-09 | R-12 | kurzeme | 84.2 | 29.2 |
| 2026-07-16 03:11:48 | refuel | V-008 | D-16 | R-11 | vidzeme | 0 | 35.3 |
| 2026-07-16 03:11:47 | trip_end | V-003 | D-06 | R-02 | kurzeme | 61.5 | 25.5 |
| 2026-07-16 03:11:44 | gps_ping | V-014 | D-10 | R-03 | kurzeme | 41.9 | 34.4 |
| 2026-07-16 03:11:44 | gps_ping | V-023 | D-18 | R-13 | latgale | 58.9 | 31.3 |
| 2026-07-16 03:11:42 | idle | V-050 | D-06 | R-12 | kurzeme | 0 | 39.7 |
| 2026-07-16 03:11:37 | gps_ping | V-049 | D-08 | R-07 | riga | 26.2 | 33.3 |
| 2026-07-16 03:11:29 | speeding | V-018 | D-20 | R-06 | vidzeme | 24.6 | 12.2 |
| 2026-07-16 03:11:27 | gps_ping | V-014 | D-08 | R-06 | vidzeme | 70.2 | 33.3 |
| 2026-07-16 03:11:26 | gps_ping | V-030 | D-02 | R-03 | kurzeme | 43 | 12.9 |
| 2026-07-16 03:11:25 | gps_ping | V-037 | D-28 | R-01 | kurzeme | 72.1 | 34.6 |
| 2026-07-16 03:11:23 | gps_ping | V-016 | D-02 | R-01 | kurzeme | 81 | 33.8 |
| 2026-07-16 03:11:20 | engine_fault | V-004 | D-17 | R-09 | riga | 53.2 | 28.5 |
| 2026-07-16 03:11:18 | trip_end | V-032 | D-30 | R-07 | riga | 40.3 | 14.6 |
| 2026-07-16 03:11:14 | engine_fault | V-015 | D-15 | R-04 | vidzeme | 49.9 | 25.8 |
| 2026-07-16 03:11:07 | gps_ping | V-014 | D-22 | R-10 | latgale | 43.2 | 27.1 |
| 2026-07-16 03:11:02 | speeding | V-046 | D-08 | R-09 | riga | 32 | 27.3 |
| 2026-07-16 03:10:59 | gps_ping | V-004 | D-24 | R-07 | riga | 70.2 | 29.7 |
| 2026-07-16 03:10:59 | idle | V-031 | D-09 | R-08 | latgale | 0 | 26.5 |
| 2026-07-16 03:10:56 | harsh_braking | V-036 | D-11 | R-07 | riga | 38.8 | 32 |
| 2026-07-16 03:10:56 | gps_ping | V-007 | D-07 | R-09 | riga | 32 | 17.2 |