События (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:34:27 | harsh_braking | V-049 | D-16 | R-04 | vidzeme | 13.6 | 33.7 |
| 2026-07-16 02:34:22 | harsh_braking | V-001 | D-07 | R-12 | kurzeme | 41.5 | 29.1 |
| 2026-07-16 02:34:21 | harsh_braking | V-040 | D-06 | R-06 | vidzeme | 74.9 | 34.8 |
| 2026-07-16 02:34:18 | gps_ping | V-003 | D-30 | R-03 | kurzeme | 61.1 | 23.9 |
| 2026-07-16 02:34:11 | gps_ping | V-007 | D-26 | R-10 | latgale | 67 | 12.2 |
| 2026-07-16 02:34:11 | gps_ping | V-036 | D-17 | R-01 | kurzeme | 48.6 | 21.1 |
| 2026-07-16 02:34:11 | gps_ping | V-010 | D-09 | R-15 | riga | 58.1 | 31.2 |
| 2026-07-16 02:34:10 | gps_ping | V-004 | D-06 | R-02 | kurzeme | 92.6 | 28 |
| 2026-07-16 02:34:06 | refuel | V-004 | D-25 | R-11 | vidzeme | 0 | 30.7 |
| 2026-07-16 02:34:01 | gps_ping | V-002 | D-02 | R-10 | latgale | 69.6 | 34.3 |
| 2026-07-16 02:33:58 | idle | V-028 | D-08 | R-05 | riga | 0 | 34.9 |
| 2026-07-16 02:33:57 | gps_ping | V-005 | D-05 | R-13 | latgale | 41.3 | 10.5 |
| 2026-07-16 02:33:49 | gps_ping | V-046 | D-22 | R-13 | latgale | 22.7 | 25.1 |
| 2026-07-16 02:33:49 | trip_end | V-037 | D-25 | R-11 | vidzeme | 77 | 33 |
| 2026-07-16 02:33:43 | gps_ping | V-017 | D-25 | R-09 | riga | 26.9 | 27.2 |
| 2026-07-16 02:33:42 | trip_end | V-008 | D-08 | R-06 | vidzeme | 51.1 | 24.9 |
| 2026-07-16 02:33:34 | refuel | V-040 | D-26 | R-13 | latgale | 0 | 32.9 |
| 2026-07-16 02:33:32 | trip_end | V-045 | D-02 | R-12 | kurzeme | 80.6 | 14.6 |
| 2026-07-16 02:33:32 | gps_ping | V-022 | D-12 | R-02 | kurzeme | 31.4 | 40 |
| 2026-07-16 02:33:27 | gps_ping | V-026 | D-21 | R-05 | riga | 73.3 | 13 |
| 2026-07-16 02:33:26 | gps_ping | V-005 | D-11 | R-07 | riga | 52.5 | 14.9 |
| 2026-07-16 02:33:26 | gps_ping | V-007 | D-23 | R-14 | latgale | 27 | 11 |
| 2026-07-16 02:33:19 | harsh_braking | V-033 | D-02 | R-14 | latgale | 54.2 | 26.3 |
| 2026-07-16 02:33:18 | gps_ping | V-037 | D-18 | R-03 | kurzeme | 54.3 | 33 |
| 2026-07-16 02:33:16 | trip_end | V-027 | D-22 | R-01 | kurzeme | 58.8 | 30.1 |
| 2026-07-16 02:33:14 | gps_ping | V-017 | D-15 | R-13 | latgale | 76.9 | 29 |
| 2026-07-16 02:33:14 | harsh_braking | V-013 | D-07 | R-03 | kurzeme | 63.9 | 16.3 |
| 2026-07-16 02:33:13 | trip_start | V-020 | D-29 | R-12 | kurzeme | 61.7 | 28.4 |
| 2026-07-16 02:33:12 | gps_ping | V-031 | D-14 | R-05 | riga | 56.7 | 30.4 |
| 2026-07-16 02:33:05 | refuel | V-040 | D-29 | R-15 | riga | 0 | 35.3 |
| 2026-07-16 02:33:05 | gps_ping | V-009 | D-08 | R-13 | latgale | 70.8 | 35.3 |
| 2026-07-16 02:32:58 | gps_ping | V-023 | D-29 | R-15 | riga | 34 | 37.7 |
| 2026-07-16 02:32:57 | gps_ping | V-043 | D-07 | R-07 | riga | 82 | 29.6 |
| 2026-07-16 02:32:55 | gps_ping | V-027 | D-15 | R-08 | latgale | 86.6 | 31.3 |
| 2026-07-16 02:32:51 | gps_ping | V-005 | D-07 | R-02 | kurzeme | 42.6 | 15.5 |
| 2026-07-16 02:32:47 | gps_ping | V-011 | D-07 | R-14 | latgale | 33.9 | 14.7 |
| 2026-07-16 02:32:44 | gps_ping | V-011 | D-03 | R-05 | riga | 30.1 | 12 |
| 2026-07-16 02:32:42 | gps_ping | V-003 | D-16 | R-13 | latgale | 88.5 | 26.9 |
| 2026-07-16 02:32:42 | gps_ping | V-021 | D-12 | R-06 | vidzeme | 90.3 | 30.9 |
| 2026-07-16 02:32:37 | gps_ping | V-003 | D-18 | R-05 | riga | 21.3 | 31.9 |
| 2026-07-16 02:32:34 | gps_ping | V-049 | D-13 | R-05 | riga | 39.2 | 31.2 |
| 2026-07-16 02:32:31 | engine_fault | V-023 | D-03 | R-05 | riga | 78.3 | 37.3 |
| 2026-07-16 02:32:27 | gps_ping | V-012 | D-25 | R-12 | kurzeme | 61.8 | 30.1 |
| 2026-07-16 02:32:22 | gps_ping | V-034 | D-09 | R-07 | riga | 27.1 | 35.1 |
| 2026-07-16 02:32:20 | gps_ping | V-038 | D-06 | R-03 | kurzeme | 76.8 | 29.1 |
| 2026-07-16 02:32:18 | speeding | V-050 | D-06 | R-01 | kurzeme | 81.1 | 25.8 |
| 2026-07-16 02:32:14 | trip_end | V-022 | D-03 | R-08 | latgale | 93.1 | 32.8 |
| 2026-07-16 02:32:14 | gps_ping | V-040 | D-07 | R-10 | latgale | 46.8 | 33.6 |
| 2026-07-16 02:32:07 | trip_start | V-028 | D-29 | R-04 | vidzeme | 32.8 | 36.2 |
| 2026-07-16 02:32:02 | trip_end | V-021 | D-07 | R-05 | riga | 69 | 32 |