События (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 03:08:43 | trip_end | V-039 | D-05 | R-12 | kurzeme | 81.6 | 14 |
| 2026-07-16 03:08:39 | gps_ping | V-048 | D-22 | R-12 | kurzeme | 48.9 | 32.6 |
| 2026-07-16 03:08:38 | gps_ping | V-019 | D-13 | R-09 | riga | 80.4 | 29.3 |
| 2026-07-16 03:08:38 | harsh_braking | V-020 | D-20 | R-02 | kurzeme | 43.6 | 29.1 |
| 2026-07-16 03:08:37 | trip_start | V-039 | D-05 | R-08 | latgale | 37.3 | 14.3 |
| 2026-07-16 03:08:36 | trip_end | V-018 | D-05 | R-10 | latgale | 43.7 | 14.7 |
| 2026-07-16 03:08:29 | gps_ping | V-031 | D-30 | R-09 | riga | 49.2 | 32.7 |
| 2026-07-16 03:08:23 | gps_ping | V-036 | D-21 | R-05 | riga | 62.7 | 30.9 |
| 2026-07-16 03:08:21 | gps_ping | V-016 | D-28 | R-06 | vidzeme | 48.5 | 32 |
| 2026-07-16 03:08:20 | gps_ping | V-050 | D-17 | R-13 | latgale | 92.7 | 26.3 |
| 2026-07-16 03:08:18 | trip_start | V-045 | D-15 | R-12 | kurzeme | 64.5 | 13 |
| 2026-07-16 03:08:14 | gps_ping | V-043 | D-21 | R-13 | latgale | 77.4 | 28.6 |
| 2026-07-16 03:08:07 | gps_ping | V-009 | D-22 | R-05 | riga | 28.5 | 29.3 |
| 2026-07-16 03:08:04 | gps_ping | V-029 | D-22 | R-03 | kurzeme | 90 | 26.1 |
| 2026-07-16 03:08:02 | harsh_braking | V-021 | D-14 | R-06 | vidzeme | 26.8 | 35.1 |
| 2026-07-16 03:08:02 | gps_ping | V-030 | D-16 | R-04 | vidzeme | 41.6 | 15.3 |
| 2026-07-16 03:07:53 | refuel | V-035 | D-18 | R-03 | kurzeme | 0 | 34.6 |
| 2026-07-16 03:07:52 | idle | V-038 | D-23 | R-10 | latgale | 0 | 27 |
| 2026-07-16 03:07:49 | trip_start | V-037 | D-15 | R-03 | kurzeme | 43.5 | 32.7 |
| 2026-07-16 03:07:45 | gps_ping | V-005 | D-27 | R-10 | latgale | 56.5 | 17 |
| 2026-07-16 03:07:45 | refuel | V-043 | D-28 | R-13 | latgale | 0 | 24.9 |
| 2026-07-16 03:07:42 | gps_ping | V-021 | D-05 | R-10 | latgale | 77 | 31.5 |
| 2026-07-16 03:07:41 | gps_ping | V-026 | D-09 | R-12 | kurzeme | 56.1 | 13.6 |
| 2026-07-16 03:07:40 | gps_ping | V-039 | D-29 | R-10 | latgale | 80.1 | 13.6 |
| 2026-07-16 03:07:39 | gps_ping | V-029 | D-05 | R-14 | latgale | 41.7 | 36.1 |
| 2026-07-16 03:07:38 | trip_start | V-023 | D-08 | R-12 | kurzeme | 76 | 35.8 |
| 2026-07-16 03:07:37 | gps_ping | V-032 | D-03 | R-07 | riga | 21.1 | 11.9 |
| 2026-07-16 03:07:36 | gps_ping | V-033 | D-07 | R-11 | vidzeme | 69.6 | 33 |
| 2026-07-16 03:07:36 | trip_start | V-026 | D-08 | R-12 | kurzeme | 93 | 14.7 |
| 2026-07-16 03:07:35 | gps_ping | V-034 | D-28 | R-06 | vidzeme | 23.8 | 27 |
| 2026-07-16 03:07:30 | gps_ping | V-023 | D-18 | R-15 | riga | 60.2 | 29.3 |
| 2026-07-16 03:07:23 | gps_ping | V-024 | D-04 | R-01 | kurzeme | 67.1 | 15.4 |
| 2026-07-16 03:07:20 | gps_ping | V-031 | D-17 | R-01 | kurzeme | 40.2 | 27.6 |
| 2026-07-16 03:07:19 | gps_ping | V-008 | D-28 | R-10 | latgale | 24.1 | 27.6 |
| 2026-07-16 03:07:15 | gps_ping | V-011 | D-10 | R-08 | latgale | 76.8 | 13.6 |
| 2026-07-16 03:07:14 | refuel | V-015 | D-05 | R-10 | latgale | 0 | 28.8 |
| 2026-07-16 03:07:08 | gps_ping | V-050 | D-22 | R-06 | vidzeme | 42.9 | 26.2 |
| 2026-07-16 03:07:03 | trip_end | V-001 | D-21 | R-07 | riga | 29.4 | 31 |
| 2026-07-16 03:07:00 | gps_ping | V-014 | D-08 | R-02 | kurzeme | 40.2 | 31.4 |
| 2026-07-16 03:06:58 | gps_ping | V-047 | D-08 | R-01 | kurzeme | 20.8 | 15.8 |
| 2026-07-16 03:06:58 | refuel | V-043 | D-30 | R-04 | vidzeme | 0 | 28.3 |
| 2026-07-16 03:06:54 | refuel | V-010 | D-29 | R-14 | latgale | 0 | 31.1 |
| 2026-07-16 03:06:53 | gps_ping | V-003 | D-05 | R-13 | latgale | 76.8 | 28.6 |
| 2026-07-16 03:06:50 | trip_end | V-042 | D-08 | R-14 | latgale | 55.5 | 30.6 |
| 2026-07-16 03:06:48 | gps_ping | V-039 | D-03 | R-13 | latgale | 91.1 | 16.8 |
| 2026-07-16 03:06:30 | gps_ping | V-010 | D-30 | R-07 | riga | 42.4 | 29.7 |
| 2026-07-16 03:06:28 | trip_end | V-045 | D-26 | R-08 | latgale | 49.8 | 15.2 |
| 2026-07-16 03:06:21 | gps_ping | V-037 | D-24 | R-03 | kurzeme | 88.5 | 44.3 |
| 2026-07-16 03:06:20 | speeding | V-013 | D-07 | R-06 | vidzeme | 78.6 | 15.1 |
| 2026-07-16 03:06:19 | trip_start | V-018 | D-07 | R-09 | riga | 80.4 | 16.7 |