События (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:12:00 | refuel | V-023 | D-24 | R-03 | kurzeme | 0 | 33.7 |
| 2026-07-16 01:12:00 | gps_ping | V-008 | D-10 | R-08 | latgale | 45.2 | 33.1 |
| 2026-07-16 01:11:59 | gps_ping | V-026 | D-28 | R-02 | kurzeme | 56.6 | 13.6 |
| 2026-07-16 01:11:57 | trip_start | V-024 | D-09 | R-01 | kurzeme | 59.2 | 12.2 |
| 2026-07-16 01:11:54 | gps_ping | V-020 | D-16 | R-04 | vidzeme | 49.5 | 29.6 |
| 2026-07-16 01:11:54 | idle | V-005 | D-02 | R-10 | latgale | 0 | 17.2 |
| 2026-07-16 01:11:48 | gps_ping | V-043 | D-05 | R-13 | latgale | 99.7 | 19.3 |
| 2026-07-16 01:11:43 | speeding | V-045 | D-24 | R-10 | latgale | 65 | 14.2 |
| 2026-07-16 01:11:36 | refuel | V-049 | D-08 | R-10 | latgale | 0 | 28 |
| 2026-07-16 01:11:31 | gps_ping | V-024 | D-22 | R-11 | vidzeme | 71.5 | 19.1 |
| 2026-07-16 01:11:28 | gps_ping | V-008 | D-17 | R-09 | riga | 42.8 | 36.2 |
| 2026-07-16 01:11:28 | trip_start | V-043 | D-28 | R-01 | kurzeme | 74.9 | 26.2 |
| 2026-07-16 01:11:24 | trip_end | V-049 | D-03 | R-08 | latgale | 28.9 | 28.9 |
| 2026-07-16 01:11:20 | refuel | V-014 | D-09 | R-13 | latgale | 0 | 42 |
| 2026-07-16 01:11:18 | idle | V-012 | D-06 | R-11 | vidzeme | 0 | 27.3 |
| 2026-07-16 01:11:17 | trip_end | V-034 | D-10 | R-05 | riga | 51.8 | 26.5 |
| 2026-07-16 01:11:11 | gps_ping | V-038 | D-06 | R-03 | kurzeme | 38.7 | 23.3 |
| 2026-07-16 01:11:11 | gps_ping | V-021 | D-25 | R-06 | vidzeme | 66.5 | 30.9 |
| 2026-07-16 01:11:08 | gps_ping | V-029 | D-18 | R-10 | latgale | 26.4 | 25.2 |
| 2026-07-16 01:11:03 | gps_ping | V-041 | D-15 | R-13 | latgale | 46.6 | 29.6 |
| 2026-07-16 01:11:02 | trip_end | V-013 | D-26 | R-03 | kurzeme | 23.8 | 16.9 |
| 2026-07-16 01:10:54 | trip_start | V-029 | D-25 | R-09 | riga | 66.8 | 24.1 |
| 2026-07-16 01:10:54 | gps_ping | V-042 | D-01 | R-03 | kurzeme | 33.7 | 33.5 |
| 2026-07-16 01:10:51 | gps_ping | V-031 | D-02 | R-11 | vidzeme | 17.8 | 36.7 |
| 2026-07-16 01:10:50 | harsh_braking | V-012 | D-06 | R-10 | latgale | 35.6 | 26 |
| 2026-07-16 01:10:47 | gps_ping | V-019 | D-04 | R-12 | kurzeme | 51.4 | 29.5 |
| 2026-07-16 01:10:46 | gps_ping | V-020 | D-25 | R-13 | latgale | 51.4 | 32.2 |
| 2026-07-16 01:10:43 | gps_ping | V-037 | D-09 | R-07 | riga | 66.7 | 39.9 |
| 2026-07-16 01:10:40 | gps_ping | V-008 | D-20 | R-07 | riga | 44 | 26.4 |
| 2026-07-16 01:10:37 | gps_ping | V-017 | D-04 | R-09 | riga | 90.9 | 32.1 |
| 2026-07-16 01:10:35 | engine_fault | V-021 | D-25 | R-07 | riga | 38.7 | 28.3 |
| 2026-07-16 01:10:33 | gps_ping | V-034 | D-30 | R-06 | vidzeme | 26.8 | 23.9 |
| 2026-07-16 01:10:33 | gps_ping | V-018 | D-16 | R-05 | riga | 23 | 15.1 |
| 2026-07-16 01:10:19 | gps_ping | V-044 | D-23 | R-03 | kurzeme | 54.7 | 22.3 |
| 2026-07-16 01:10:12 | gps_ping | V-024 | D-09 | R-15 | riga | 28.2 | 10.4 |
| 2026-07-16 01:10:12 | gps_ping | V-035 | D-09 | R-12 | kurzeme | 90 | 29.3 |
| 2026-07-16 01:10:08 | gps_ping | V-033 | D-24 | R-04 | vidzeme | 32.4 | 29.3 |
| 2026-07-16 01:10:04 | trip_start | V-036 | D-18 | R-04 | vidzeme | 30 | 27.8 |
| 2026-07-16 01:10:01 | idle | V-045 | D-15 | R-06 | vidzeme | 0 | 13.3 |
| 2026-07-16 01:09:56 | gps_ping | V-005 | D-19 | R-14 | latgale | 46.8 | 20.3 |
| 2026-07-16 01:09:54 | gps_ping | V-005 | D-19 | R-02 | kurzeme | 42 | 16.4 |
| 2026-07-16 01:09:54 | gps_ping | V-033 | D-03 | R-13 | latgale | 35 | 29.1 |
| 2026-07-16 01:09:49 | gps_ping | V-040 | D-28 | R-08 | latgale | 46.5 | 41.9 |
| 2026-07-16 01:09:46 | speeding | V-013 | D-04 | R-09 | riga | 32.6 | 13.2 |
| 2026-07-16 01:09:40 | gps_ping | V-022 | D-17 | R-05 | riga | 80.3 | 27.6 |
| 2026-07-16 01:09:38 | trip_end | V-050 | D-25 | R-08 | latgale | 71 | 32 |
| 2026-07-16 01:09:37 | gps_ping | V-048 | D-16 | R-01 | kurzeme | 32.5 | 28.8 |
| 2026-07-16 01:09:33 | refuel | V-029 | D-19 | R-14 | latgale | 0 | 29.5 |
| 2026-07-16 01:09:32 | refuel | V-027 | D-03 | R-01 | kurzeme | 0 | 32.3 |
| 2026-07-16 01:09:32 | gps_ping | V-008 | D-12 | R-06 | vidzeme | 47.4 | 25.6 |