События (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:55:03 | gps_ping | V-018 | D-06 | R-07 | riga | 63.8 | 14.5 |
| 2026-07-16 02:55:00 | gps_ping | V-025 | D-08 | R-15 | riga | 82 | 31.5 |
| 2026-07-16 02:55:00 | gps_ping | V-046 | D-12 | R-15 | riga | 44.7 | 27.5 |
| 2026-07-16 02:55:00 | gps_ping | V-006 | D-13 | R-07 | riga | 19 | 28.8 |
| 2026-07-16 02:54:57 | engine_fault | V-044 | D-19 | R-08 | latgale | 35.2 | 31.4 |
| 2026-07-16 02:54:53 | idle | V-018 | D-09 | R-03 | kurzeme | 0 | 15.9 |
| 2026-07-16 02:54:52 | gps_ping | V-006 | D-14 | R-14 | latgale | 51 | 29.6 |
| 2026-07-16 02:54:48 | gps_ping | V-028 | D-05 | R-07 | riga | 39.1 | 30.6 |
| 2026-07-16 02:54:47 | engine_fault | V-043 | D-02 | R-14 | latgale | 61 | 27.2 |
| 2026-07-16 02:54:46 | gps_ping | V-047 | D-26 | R-01 | kurzeme | 65.6 | 9.9 |
| 2026-07-16 02:54:45 | gps_ping | V-030 | D-03 | R-15 | riga | 37.1 | 15.9 |
| 2026-07-16 02:54:45 | gps_ping | V-022 | D-14 | R-04 | vidzeme | 56.4 | 26.4 |
| 2026-07-16 02:54:42 | trip_end | V-003 | D-27 | R-12 | kurzeme | 74.6 | 25 |
| 2026-07-16 02:54:39 | engine_fault | V-016 | D-21 | R-08 | latgale | 61.7 | 29.4 |
| 2026-07-16 02:54:39 | gps_ping | V-029 | D-01 | R-14 | latgale | 61.7 | 28.5 |
| 2026-07-16 02:54:33 | speeding | V-005 | D-10 | R-03 | kurzeme | 37.8 | 17.1 |
| 2026-07-16 02:54:29 | refuel | V-025 | D-24 | R-02 | kurzeme | 0 | 27.3 |
| 2026-07-16 02:54:25 | speeding | V-025 | D-03 | R-13 | latgale | 41.4 | 27.5 |
| 2026-07-16 02:54:25 | gps_ping | V-003 | D-11 | R-10 | latgale | 48.5 | 29.5 |
| 2026-07-16 02:54:24 | speeding | V-029 | D-13 | R-13 | latgale | 64.6 | 26.4 |
| 2026-07-16 02:54:22 | gps_ping | V-022 | D-10 | R-01 | kurzeme | 47 | 29.7 |
| 2026-07-16 02:54:21 | gps_ping | V-020 | D-18 | R-03 | kurzeme | 31.4 | 29.4 |
| 2026-07-16 02:54:16 | gps_ping | V-029 | D-01 | R-03 | kurzeme | 89.8 | 29.8 |
| 2026-07-16 02:54:14 | trip_start | V-037 | D-29 | R-07 | riga | 59.6 | 32.6 |
| 2026-07-16 02:54:09 | gps_ping | V-040 | D-10 | R-05 | riga | 34.4 | 32.7 |
| 2026-07-16 02:54:03 | gps_ping | V-040 | D-20 | R-07 | riga | 43.6 | 38.9 |
| 2026-07-16 02:54:01 | gps_ping | V-012 | D-23 | R-10 | latgale | 36.7 | 26.1 |
| 2026-07-16 02:54:00 | gps_ping | V-011 | D-05 | R-03 | kurzeme | 37.8 | 15.1 |
| 2026-07-16 02:53:50 | gps_ping | V-036 | D-05 | R-13 | latgale | 59.9 | 26.7 |
| 2026-07-16 02:53:48 | gps_ping | V-022 | D-01 | R-08 | latgale | 69.5 | 32.5 |
| 2026-07-16 02:53:47 | refuel | V-050 | D-18 | R-09 | riga | 0 | 27.1 |
| 2026-07-16 02:53:45 | trip_start | V-030 | D-03 | R-11 | vidzeme | 77.6 | 12.4 |
| 2026-07-16 02:53:40 | idle | V-042 | D-25 | R-13 | latgale | 0 | 32.2 |
| 2026-07-16 02:53:39 | trip_start | V-006 | D-03 | R-08 | latgale | 34.5 | 29.4 |
| 2026-07-16 02:53:39 | gps_ping | V-015 | D-28 | R-09 | riga | 63 | 28.2 |
| 2026-07-16 02:53:37 | gps_ping | V-011 | D-25 | R-03 | kurzeme | 34 | 16.3 |
| 2026-07-16 02:53:37 | gps_ping | V-046 | D-15 | R-08 | latgale | 27.7 | 28.9 |
| 2026-07-16 02:53:32 | gps_ping | V-020 | D-28 | R-02 | kurzeme | 61.8 | 33 |
| 2026-07-16 02:53:30 | gps_ping | V-005 | D-06 | R-11 | vidzeme | 36.5 | 17.9 |
| 2026-07-16 02:53:29 | trip_start | V-003 | D-21 | R-04 | vidzeme | 17.1 | 26.8 |
| 2026-07-16 02:53:29 | trip_start | V-001 | D-05 | R-09 | riga | 60 | 28.2 |
| 2026-07-16 02:53:24 | harsh_braking | V-003 | D-09 | R-04 | vidzeme | 53 | 33.2 |
| 2026-07-16 02:53:23 | gps_ping | V-038 | D-18 | R-03 | kurzeme | 42.1 | 31.8 |
| 2026-07-16 02:53:21 | engine_fault | V-016 | D-14 | R-10 | latgale | 43 | 35.3 |
| 2026-07-16 02:53:20 | gps_ping | V-003 | D-28 | R-11 | vidzeme | 24.6 | 20.4 |
| 2026-07-16 02:53:18 | harsh_braking | V-003 | D-13 | R-13 | latgale | 83.9 | 28.7 |
| 2026-07-16 02:53:13 | trip_start | V-011 | D-30 | R-04 | vidzeme | 40.6 | 16.2 |
| 2026-07-16 02:53:10 | gps_ping | V-032 | D-28 | R-07 | riga | 83.6 | 15.1 |
| 2026-07-16 02:53:09 | gps_ping | V-009 | D-15 | R-04 | vidzeme | 23.4 | 34.9 |
| 2026-07-16 02:53:01 | gps_ping | V-012 | D-27 | R-04 | vidzeme | 60.8 | 26.1 |