События (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:14:10 | gps_ping | V-039 | D-01 | R-10 | latgale | 59.3 | 16.5 |
| 2026-07-16 01:14:09 | refuel | V-041 | D-05 | R-01 | kurzeme | 0 | 28.7 |
| 2026-07-16 01:14:07 | trip_end | V-015 | D-12 | R-01 | kurzeme | 66.5 | 24.6 |
| 2026-07-16 01:14:02 | trip_start | V-011 | D-14 | R-08 | latgale | 74.5 | 18.1 |
| 2026-07-16 01:14:02 | harsh_braking | V-041 | D-24 | R-05 | riga | 57.7 | 31.8 |
| 2026-07-16 01:14:01 | trip_start | V-001 | D-02 | R-11 | vidzeme | 21.1 | 24.8 |
| 2026-07-16 01:13:54 | idle | V-034 | D-21 | R-12 | kurzeme | 0 | 29.4 |
| 2026-07-16 01:13:54 | gps_ping | V-020 | D-28 | R-07 | riga | 33.9 | 27.7 |
| 2026-07-16 01:13:52 | engine_fault | V-014 | D-13 | R-11 | vidzeme | 57.5 | 33.9 |
| 2026-07-16 01:13:52 | gps_ping | V-006 | D-16 | R-10 | latgale | 60.3 | 29.4 |
| 2026-07-16 01:13:52 | harsh_braking | V-040 | D-07 | R-06 | vidzeme | 54.6 | 36 |
| 2026-07-16 01:13:52 | gps_ping | V-044 | D-21 | R-08 | latgale | 26.7 | 27.7 |
| 2026-07-16 01:13:48 | gps_ping | V-036 | D-19 | R-03 | kurzeme | 51.4 | 33.7 |
| 2026-07-16 01:13:46 | gps_ping | V-018 | D-14 | R-01 | kurzeme | 28.4 | 14.6 |
| 2026-07-16 01:13:45 | gps_ping | V-034 | D-05 | R-14 | latgale | 79.7 | 26.3 |
| 2026-07-16 01:13:42 | harsh_braking | V-046 | D-30 | R-02 | kurzeme | 70.2 | 31.1 |
| 2026-07-16 01:13:39 | gps_ping | V-017 | D-23 | R-08 | latgale | 58.8 | 28.1 |
| 2026-07-16 01:13:39 | gps_ping | V-022 | D-15 | R-06 | vidzeme | 53.3 | 29.1 |
| 2026-07-16 01:13:26 | idle | V-023 | D-09 | R-08 | latgale | 0 | 37.2 |
| 2026-07-16 01:13:18 | gps_ping | V-012 | D-05 | R-13 | latgale | 49.1 | 24.9 |
| 2026-07-16 01:13:10 | gps_ping | V-021 | D-27 | R-15 | riga | 22 | 36.3 |
| 2026-07-16 01:13:04 | gps_ping | V-010 | D-14 | R-08 | latgale | 33.9 | 27.1 |
| 2026-07-16 01:13:04 | gps_ping | V-048 | D-15 | R-15 | riga | 26.8 | 28.2 |
| 2026-07-16 01:13:00 | gps_ping | V-008 | D-01 | R-06 | vidzeme | 59.1 | 22.8 |
| 2026-07-16 01:12:54 | gps_ping | V-035 | D-12 | R-15 | riga | 42.9 | 31.2 |
| 2026-07-16 01:12:50 | gps_ping | V-002 | D-28 | R-04 | vidzeme | 55.1 | 35.1 |
| 2026-07-16 01:12:43 | idle | V-036 | D-09 | R-14 | latgale | 0 | 28 |
| 2026-07-16 01:12:42 | gps_ping | V-047 | D-05 | R-04 | vidzeme | 52.4 | 18.7 |
| 2026-07-16 01:12:40 | idle | V-038 | D-23 | R-04 | vidzeme | 0 | 30 |
| 2026-07-16 01:12:38 | trip_start | V-044 | D-17 | R-08 | latgale | 39.2 | 28.8 |
| 2026-07-16 01:12:36 | idle | V-018 | D-05 | R-10 | latgale | 0 | 15.6 |
| 2026-07-16 01:12:35 | gps_ping | V-029 | D-27 | R-05 | riga | 72 | 26.1 |
| 2026-07-16 01:12:34 | idle | V-042 | D-17 | R-09 | riga | 0 | 28.4 |
| 2026-07-16 01:12:33 | gps_ping | V-005 | D-25 | R-13 | latgale | 29.2 | 19.2 |
| 2026-07-16 01:12:22 | engine_fault | V-038 | D-15 | R-10 | latgale | 46.9 | 25.6 |
| 2026-07-16 01:12:22 | gps_ping | V-007 | D-07 | R-01 | kurzeme | 72.6 | 12 |
| 2026-07-16 01:12:22 | gps_ping | V-027 | D-10 | R-12 | kurzeme | 87.8 | 29.2 |
| 2026-07-16 01:12:16 | harsh_braking | V-026 | D-03 | R-12 | kurzeme | 34.3 | 12.8 |
| 2026-07-16 01:12:16 | gps_ping | V-015 | D-18 | R-09 | riga | 21.4 | 27.4 |
| 2026-07-16 01:12:09 | speeding | V-036 | D-24 | R-02 | kurzeme | 47.6 | 28.9 |
| 2026-07-16 01:12:08 | trip_start | V-003 | D-27 | R-02 | kurzeme | 94.8 | 27.5 |
| 2026-07-16 01:12:08 | trip_end | V-039 | D-26 | R-14 | latgale | 87.3 | 12.4 |
| 2026-07-16 01:12:07 | gps_ping | V-021 | D-25 | R-14 | latgale | 60.6 | 35.1 |
| 2026-07-16 01:12:07 | gps_ping | V-042 | D-01 | R-08 | latgale | 28.8 | 35.4 |
| 2026-07-16 01:12:05 | refuel | V-016 | D-27 | R-06 | vidzeme | 0 | 26.2 |
| 2026-07-16 01:12:04 | gps_ping | V-048 | D-04 | R-03 | kurzeme | 54.5 | 28.3 |
| 2026-07-16 01:12:04 | trip_end | V-003 | D-03 | R-12 | kurzeme | 68.3 | 33.4 |
| 2026-07-16 01:12:02 | gps_ping | V-018 | D-26 | R-06 | vidzeme | 70 | 13.3 |
| 2026-07-16 01:12:02 | gps_ping | V-045 | D-07 | R-13 | latgale | 40.6 | 13.3 |
| 2026-07-16 01:12:01 | gps_ping | V-014 | D-14 | R-08 | latgale | 29.5 | 38.7 |