События (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 01:20:49 | gps_ping | V-025 | D-09 | R-07 | riga | 52.6 | 28.3 |
| 2026-07-16 01:20:45 | trip_start | V-048 | D-21 | R-11 | vidzeme | 46.2 | 25.3 |
| 2026-07-16 01:20:43 | trip_end | V-018 | D-23 | R-09 | riga | 27.6 | 10.1 |
| 2026-07-16 01:20:43 | speeding | V-034 | D-18 | R-02 | kurzeme | 26.1 | 21.8 |
| 2026-07-16 01:20:41 | gps_ping | V-026 | D-22 | R-12 | kurzeme | 77.6 | 13.2 |
| 2026-07-16 01:20:36 | trip_start | V-046 | D-16 | R-13 | latgale | 69 | 37 |
| 2026-07-16 01:20:25 | gps_ping | V-021 | D-29 | R-03 | kurzeme | 43.2 | 33.2 |
| 2026-07-16 01:20:22 | gps_ping | V-034 | D-16 | R-04 | vidzeme | 52.6 | 25.3 |
| 2026-07-16 01:20:19 | gps_ping | V-005 | D-23 | R-12 | kurzeme | 45 | 14 |
| 2026-07-16 01:20:19 | trip_end | V-045 | D-17 | R-13 | latgale | 80.1 | 14.9 |
| 2026-07-16 01:20:19 | gps_ping | V-048 | D-08 | R-10 | latgale | 64.6 | 26.9 |
| 2026-07-16 01:20:10 | gps_ping | V-017 | D-21 | R-09 | riga | 87.9 | 30.7 |
| 2026-07-16 01:20:08 | gps_ping | V-020 | D-12 | R-03 | kurzeme | 26.2 | 30.9 |
| 2026-07-16 01:20:08 | gps_ping | V-042 | D-23 | R-08 | latgale | 70.6 | 30.9 |
| 2026-07-16 01:20:07 | gps_ping | V-045 | D-28 | R-14 | latgale | 77.6 | 16.6 |
| 2026-07-16 01:20:05 | trip_start | V-034 | D-16 | R-11 | vidzeme | 40.2 | 22.2 |
| 2026-07-16 01:19:59 | gps_ping | V-019 | D-01 | R-05 | riga | 58.9 | 29.5 |
| 2026-07-16 01:19:55 | trip_start | V-008 | D-22 | R-04 | vidzeme | 64.3 | 22.8 |
| 2026-07-16 01:19:50 | trip_end | V-039 | D-10 | R-11 | vidzeme | 47.3 | 13.6 |
| 2026-07-16 01:19:49 | gps_ping | V-036 | D-28 | R-09 | riga | 66.8 | 27 |
| 2026-07-16 01:19:47 | gps_ping | V-007 | D-03 | R-03 | kurzeme | 89.9 | 12.3 |
| 2026-07-16 01:19:45 | speeding | V-042 | D-18 | R-01 | kurzeme | 65.8 | 30.7 |
| 2026-07-16 01:19:41 | gps_ping | V-037 | D-29 | R-02 | kurzeme | 33.3 | 44.9 |
| 2026-07-16 01:19:34 | refuel | V-024 | D-18 | R-08 | latgale | 0 | 12.6 |
| 2026-07-16 01:19:31 | gps_ping | V-039 | D-10 | R-05 | riga | 32.1 | 10.3 |
| 2026-07-16 01:19:31 | refuel | V-048 | D-26 | R-02 | kurzeme | 0 | 26.1 |
| 2026-07-16 01:19:29 | gps_ping | V-005 | D-25 | R-02 | kurzeme | 42 | 13.9 |
| 2026-07-16 01:19:22 | engine_fault | V-017 | D-29 | R-02 | kurzeme | 82.9 | 25.7 |
| 2026-07-16 01:19:19 | refuel | V-002 | D-28 | R-09 | riga | 0 | 32.7 |
| 2026-07-16 01:19:19 | trip_end | V-021 | D-03 | R-08 | latgale | 78.5 | 33.4 |
| 2026-07-16 01:19:19 | refuel | V-026 | D-16 | R-14 | latgale | 0 | 14 |
| 2026-07-16 01:19:17 | refuel | V-050 | D-16 | R-06 | vidzeme | 0 | 30 |
| 2026-07-16 01:19:13 | idle | V-036 | D-08 | R-14 | latgale | 0 | 23.7 |
| 2026-07-16 01:19:12 | gps_ping | V-012 | D-24 | R-13 | latgale | 80.4 | 28.5 |
| 2026-07-16 01:19:11 | refuel | V-023 | D-25 | R-05 | riga | 0 | 34.7 |
| 2026-07-16 01:19:09 | gps_ping | V-020 | D-05 | R-11 | vidzeme | 45.1 | 28.4 |
| 2026-07-16 01:19:06 | trip_start | V-041 | D-11 | R-13 | latgale | 77.6 | 29.4 |
| 2026-07-16 01:19:04 | gps_ping | V-009 | D-01 | R-07 | riga | 56.4 | 28.1 |
| 2026-07-16 01:18:59 | speeding | V-019 | D-18 | R-05 | riga | 29.7 | 26.3 |
| 2026-07-16 01:18:58 | harsh_braking | V-030 | D-12 | R-05 | riga | 62.1 | 13.2 |
| 2026-07-16 01:18:54 | gps_ping | V-035 | D-26 | R-05 | riga | 22.3 | 33.4 |
| 2026-07-16 01:18:52 | speeding | V-011 | D-17 | R-05 | riga | 69.4 | 15.5 |
| 2026-07-16 01:18:47 | gps_ping | V-005 | D-07 | R-01 | kurzeme | 45 | 16.4 |
| 2026-07-16 01:18:46 | refuel | V-030 | D-25 | R-07 | riga | 0 | 13.9 |
| 2026-07-16 01:18:45 | idle | V-008 | D-11 | R-07 | riga | 0 | 23.1 |
| 2026-07-16 01:18:43 | gps_ping | V-033 | D-09 | R-11 | vidzeme | 30 | 29.1 |
| 2026-07-16 01:18:41 | gps_ping | V-028 | D-18 | R-15 | riga | 84.1 | 34.1 |
| 2026-07-16 01:18:41 | gps_ping | V-035 | D-25 | R-04 | vidzeme | 23.4 | 35.8 |
| 2026-07-16 01:18:40 | speeding | V-007 | D-24 | R-06 | vidzeme | 73.9 | 10.7 |
| 2026-07-16 01:18:33 | refuel | V-044 | D-03 | R-14 | latgale | 0 | 41.8 |