События (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 02:40:26 | gps_ping | V-042 | D-10 | R-03 | kurzeme | 92.5 | 34.1 |
| 2026-07-16 02:40:26 | harsh_braking | V-010 | D-09 | R-11 | vidzeme | 52.9 | 31.6 |
| 2026-07-16 02:40:24 | gps_ping | V-016 | D-17 | R-15 | riga | 71.1 | 34.9 |
| 2026-07-16 02:40:23 | gps_ping | V-048 | D-13 | R-15 | riga | 87.3 | 28.5 |
| 2026-07-16 02:40:19 | idle | V-012 | D-03 | R-07 | riga | 0 | 25.3 |
| 2026-07-16 02:40:14 | gps_ping | V-020 | D-26 | R-02 | kurzeme | 48.6 | 28.2 |
| 2026-07-16 02:40:13 | trip_start | V-040 | D-14 | R-09 | riga | 15 | 37.1 |
| 2026-07-16 02:40:08 | gps_ping | V-034 | D-17 | R-12 | kurzeme | 56.6 | 29.3 |
| 2026-07-16 02:40:07 | idle | V-022 | D-28 | R-13 | latgale | 0 | 28.9 |
| 2026-07-16 02:40:06 | gps_ping | V-042 | D-03 | R-10 | latgale | 78.5 | 31.8 |
| 2026-07-16 02:40:04 | trip_start | V-011 | D-05 | R-15 | riga | 27.2 | 16.7 |
| 2026-07-16 02:40:03 | harsh_braking | V-001 | D-17 | R-01 | kurzeme | 39.8 | 24.5 |
| 2026-07-16 02:40:02 | gps_ping | V-001 | D-24 | R-07 | riga | 42 | 29 |
| 2026-07-16 02:39:56 | gps_ping | V-005 | D-27 | R-04 | vidzeme | 59.4 | 12.9 |
| 2026-07-16 02:39:53 | gps_ping | V-019 | D-02 | R-10 | latgale | 57.9 | 28.5 |
| 2026-07-16 02:39:52 | gps_ping | V-011 | D-22 | R-05 | riga | 36.4 | 15.6 |
| 2026-07-16 02:39:51 | gps_ping | V-039 | D-25 | R-13 | latgale | 81.2 | 12.2 |
| 2026-07-16 02:39:51 | gps_ping | V-040 | D-20 | R-06 | vidzeme | 83.7 | 36 |
| 2026-07-16 02:39:51 | gps_ping | V-034 | D-16 | R-03 | kurzeme | 36 | 34.1 |
| 2026-07-16 02:39:50 | speeding | V-019 | D-20 | R-15 | riga | 52.7 | 25.2 |
| 2026-07-16 02:39:50 | refuel | V-032 | D-02 | R-11 | vidzeme | 0 | 13.6 |
| 2026-07-16 02:39:49 | engine_fault | V-001 | D-28 | R-02 | kurzeme | 44.7 | 29.9 |
| 2026-07-16 02:39:48 | gps_ping | V-025 | D-13 | R-06 | vidzeme | 82.6 | 28.4 |
| 2026-07-16 02:39:45 | gps_ping | V-043 | D-29 | R-13 | latgale | 37.9 | 30.7 |
| 2026-07-16 02:39:44 | gps_ping | V-009 | D-22 | R-05 | riga | 67.5 | 36.3 |
| 2026-07-16 02:39:42 | trip_end | V-010 | D-09 | R-15 | riga | 81.5 | 30.6 |
| 2026-07-16 02:39:36 | trip_start | V-037 | D-20 | R-01 | kurzeme | 34.9 | 32.3 |
| 2026-07-16 02:39:34 | trip_start | V-029 | D-13 | R-13 | latgale | 43.2 | 23.4 |
| 2026-07-16 02:39:33 | gps_ping | V-016 | D-06 | R-03 | kurzeme | 69.4 | 34.3 |
| 2026-07-16 02:39:29 | gps_ping | V-020 | D-12 | R-10 | latgale | 68.6 | 26.9 |
| 2026-07-16 02:39:28 | gps_ping | V-024 | D-15 | R-08 | latgale | 36.8 | 15.1 |
| 2026-07-16 02:39:25 | gps_ping | V-043 | D-13 | R-07 | riga | 59.1 | 28.9 |
| 2026-07-16 02:39:23 | speeding | V-018 | D-23 | R-01 | kurzeme | 71.8 | 15.8 |
| 2026-07-16 02:39:20 | gps_ping | V-007 | D-19 | R-11 | vidzeme | 25.4 | 12.8 |
| 2026-07-16 02:39:17 | gps_ping | V-005 | D-06 | R-07 | riga | 50.6 | 14.4 |
| 2026-07-16 02:39:12 | gps_ping | V-024 | D-10 | R-07 | riga | 68.2 | 11.2 |
| 2026-07-16 02:39:09 | trip_start | V-030 | D-06 | R-03 | kurzeme | 73.4 | 15.8 |
| 2026-07-16 02:39:08 | gps_ping | V-049 | D-28 | R-12 | kurzeme | 68.1 | 32 |
| 2026-07-16 02:39:06 | speeding | V-007 | D-22 | R-02 | kurzeme | 35.3 | 13.6 |
| 2026-07-16 02:39:05 | gps_ping | V-032 | D-22 | R-04 | vidzeme | 47.4 | 12.2 |
| 2026-07-16 02:39:05 | gps_ping | V-037 | D-02 | R-02 | kurzeme | 89.9 | 33.1 |
| 2026-07-16 02:39:04 | trip_end | V-032 | D-22 | R-03 | kurzeme | 48.7 | 15 |
| 2026-07-16 02:39:02 | trip_start | V-005 | D-25 | R-15 | riga | 63.6 | 16.6 |
| 2026-07-16 02:39:02 | gps_ping | V-010 | D-29 | R-01 | kurzeme | 18.4 | 24.2 |
| 2026-07-16 02:39:02 | gps_ping | V-032 | D-06 | R-14 | latgale | 54.6 | 13.3 |
| 2026-07-16 02:39:01 | gps_ping | V-023 | D-23 | R-05 | riga | 85.1 | 30.9 |
| 2026-07-16 02:38:56 | harsh_braking | V-021 | D-16 | R-03 | kurzeme | 96.5 | 30.9 |
| 2026-07-16 02:38:56 | trip_end | V-029 | D-10 | R-12 | kurzeme | 81 | 33 |
| 2026-07-16 02:38:56 | gps_ping | V-007 | D-01 | R-02 | kurzeme | 50.4 | 14.7 |
| 2026-07-16 02:38:56 | gps_ping | V-023 | D-14 | R-10 | latgale | 38.6 | 28.5 |