События (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:36:47 | gps_ping | V-010 | D-05 | R-09 | riga | 41.9 | 38.3 |
| 2026-07-16 02:36:45 | harsh_braking | V-025 | D-19 | R-12 | kurzeme | 42.5 | 22.6 |
| 2026-07-16 02:36:44 | gps_ping | V-026 | D-28 | R-01 | kurzeme | 61.9 | 19.7 |
| 2026-07-16 02:36:31 | gps_ping | V-040 | D-25 | R-06 | vidzeme | 100.4 | 43.1 |
| 2026-07-16 02:36:29 | gps_ping | V-047 | D-13 | R-06 | vidzeme | 82.6 | 15.7 |
| 2026-07-16 02:36:29 | gps_ping | V-035 | D-06 | R-03 | kurzeme | 69.5 | 38.7 |
| 2026-07-16 02:36:28 | trip_start | V-014 | D-01 | R-10 | latgale | 47.7 | 35.4 |
| 2026-07-16 02:36:24 | gps_ping | V-024 | D-03 | R-01 | kurzeme | 27.4 | 15.8 |
| 2026-07-16 02:36:21 | gps_ping | V-045 | D-06 | R-08 | latgale | 75.4 | 12.9 |
| 2026-07-16 02:36:19 | gps_ping | V-022 | D-19 | R-09 | riga | 30.4 | 29.6 |
| 2026-07-16 02:36:16 | speeding | V-029 | D-24 | R-09 | riga | 68.3 | 26.5 |
| 2026-07-16 02:36:14 | engine_fault | V-047 | D-08 | R-04 | vidzeme | 35 | 17.9 |
| 2026-07-16 02:36:11 | gps_ping | V-026 | D-01 | R-15 | riga | 60.6 | 11.1 |
| 2026-07-16 02:36:06 | gps_ping | V-029 | D-15 | R-15 | riga | 54.9 | 29.1 |
| 2026-07-16 02:36:04 | gps_ping | V-034 | D-04 | R-06 | vidzeme | 86.8 | 37.1 |
| 2026-07-16 02:35:56 | gps_ping | V-035 | D-30 | R-14 | latgale | 48.6 | 38.9 |
| 2026-07-16 02:35:53 | gps_ping | V-050 | D-13 | R-07 | riga | 63.9 | 33.4 |
| 2026-07-16 02:35:53 | gps_ping | V-047 | D-17 | R-06 | vidzeme | 82.5 | 11.4 |
| 2026-07-16 02:35:51 | gps_ping | V-036 | D-07 | R-03 | kurzeme | 31.7 | 27.7 |
| 2026-07-16 02:35:51 | trip_start | V-047 | D-07 | R-03 | kurzeme | 61.8 | 12.9 |
| 2026-07-16 02:35:51 | gps_ping | V-020 | D-08 | R-02 | kurzeme | 76 | 24.8 |
| 2026-07-16 02:35:47 | gps_ping | V-001 | D-16 | R-09 | riga | 23.9 | 24.7 |
| 2026-07-16 02:35:43 | trip_end | V-011 | D-28 | R-02 | kurzeme | 36.8 | 13.9 |
| 2026-07-16 02:35:39 | gps_ping | V-031 | D-26 | R-06 | vidzeme | 54.4 | 30 |
| 2026-07-16 02:35:34 | gps_ping | V-004 | D-23 | R-13 | latgale | 85.3 | 29.1 |
| 2026-07-16 02:35:23 | gps_ping | V-034 | D-26 | R-02 | kurzeme | 75.2 | 25.7 |
| 2026-07-16 02:35:23 | idle | V-029 | D-20 | R-10 | latgale | 0 | 23.6 |
| 2026-07-16 02:35:23 | gps_ping | V-045 | D-03 | R-04 | vidzeme | 20.2 | 13.9 |
| 2026-07-16 02:35:16 | gps_ping | V-021 | D-06 | R-15 | riga | 29.2 | 33.6 |
| 2026-07-16 02:35:15 | harsh_braking | V-011 | D-16 | R-01 | kurzeme | 70.3 | 15.1 |
| 2026-07-16 02:35:15 | gps_ping | V-046 | D-15 | R-11 | vidzeme | 78.4 | 28.9 |
| 2026-07-16 02:35:13 | gps_ping | V-006 | D-18 | R-06 | vidzeme | 64.6 | 27.7 |
| 2026-07-16 02:35:09 | gps_ping | V-024 | D-10 | R-10 | latgale | 85.4 | 11.5 |
| 2026-07-16 02:35:07 | gps_ping | V-029 | D-23 | R-11 | vidzeme | 54.5 | 22.4 |
| 2026-07-16 02:35:00 | gps_ping | V-008 | D-15 | R-09 | riga | 69.9 | 24.5 |
| 2026-07-16 02:35:00 | gps_ping | V-025 | D-08 | R-10 | latgale | 76.7 | 25.3 |
| 2026-07-16 02:34:59 | refuel | V-026 | D-24 | R-12 | kurzeme | 0 | 13.8 |
| 2026-07-16 02:34:55 | gps_ping | V-020 | D-02 | R-03 | kurzeme | 41.3 | 28.6 |
| 2026-07-16 02:34:51 | gps_ping | V-050 | D-01 | R-07 | riga | 51 | 31.6 |
| 2026-07-16 02:34:49 | refuel | V-044 | D-15 | R-12 | kurzeme | 0 | 26.9 |
| 2026-07-16 02:34:49 | gps_ping | V-027 | D-07 | R-07 | riga | 41.5 | 32.7 |
| 2026-07-16 02:34:45 | idle | V-029 | D-27 | R-14 | latgale | 0 | 25.6 |
| 2026-07-16 02:34:41 | gps_ping | V-021 | D-05 | R-01 | kurzeme | 82.8 | 45.1 |
| 2026-07-16 02:34:40 | gps_ping | V-026 | D-03 | R-04 | vidzeme | 47.3 | 15 |
| 2026-07-16 02:34:38 | gps_ping | V-039 | D-29 | R-11 | vidzeme | 54.6 | 18.5 |
| 2026-07-16 02:34:36 | gps_ping | V-034 | D-06 | R-05 | riga | 73.3 | 27.3 |
| 2026-07-16 02:34:36 | trip_start | V-037 | D-29 | R-14 | latgale | 41.5 | 29.5 |
| 2026-07-16 02:34:34 | gps_ping | V-032 | D-16 | R-06 | vidzeme | 49.5 | 13.4 |
| 2026-07-16 02:34:33 | gps_ping | V-046 | D-29 | R-12 | kurzeme | 55.9 | 28.2 |
| 2026-07-16 02:34:31 | gps_ping | V-043 | D-06 | R-01 | kurzeme | 43.8 | 26.2 |