События (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:21:15 | gps_ping | V-030 | D-12 | R-06 | vidzeme | 24.3 | 15.3 |
| 2026-07-16 02:21:02 | gps_ping | V-024 | D-19 | R-12 | kurzeme | 42.3 | 13.2 |
| 2026-07-16 02:20:59 | gps_ping | V-009 | D-22 | R-04 | vidzeme | 27.1 | 31.4 |
| 2026-07-16 02:20:59 | trip_start | V-027 | D-09 | R-04 | vidzeme | 26.9 | 25 |
| 2026-07-16 02:20:56 | gps_ping | V-013 | D-29 | R-04 | vidzeme | 39.6 | 16.3 |
| 2026-07-16 02:20:53 | gps_ping | V-030 | D-13 | R-11 | vidzeme | 83.2 | 11.2 |
| 2026-07-16 02:20:50 | idle | V-013 | D-15 | R-05 | riga | 0 | 14.9 |
| 2026-07-16 02:20:46 | gps_ping | V-011 | D-26 | R-09 | riga | 40.7 | 10.5 |
| 2026-07-16 02:20:45 | gps_ping | V-005 | D-22 | R-06 | vidzeme | 31 | 10 |
| 2026-07-16 02:20:44 | gps_ping | V-029 | D-22 | R-08 | latgale | 41.9 | 31 |
| 2026-07-16 02:20:40 | gps_ping | V-048 | D-14 | R-12 | kurzeme | 29.1 | 39.3 |
| 2026-07-16 02:20:38 | gps_ping | V-019 | D-22 | R-08 | latgale | 46.3 | 23.3 |
| 2026-07-16 02:20:32 | engine_fault | V-018 | D-19 | R-04 | vidzeme | 29.7 | 13.6 |
| 2026-07-16 02:20:32 | refuel | V-007 | D-19 | R-13 | latgale | 0 | 12 |
| 2026-07-16 02:20:31 | speeding | V-048 | D-10 | R-02 | kurzeme | 23.9 | 28.6 |
| 2026-07-16 02:20:30 | harsh_braking | V-015 | D-03 | R-03 | kurzeme | 61 | 30.2 |
| 2026-07-16 02:20:30 | gps_ping | V-018 | D-23 | R-02 | kurzeme | 48.4 | 17.3 |
| 2026-07-16 02:20:28 | gps_ping | V-038 | D-19 | R-15 | riga | 32.6 | 23.6 |
| 2026-07-16 02:20:27 | gps_ping | V-046 | D-25 | R-11 | vidzeme | 17.6 | 33.6 |
| 2026-07-16 02:20:24 | gps_ping | V-027 | D-01 | R-08 | latgale | 82.5 | 26.1 |
| 2026-07-16 02:20:24 | gps_ping | V-050 | D-04 | R-14 | latgale | 67.1 | 26.9 |
| 2026-07-16 02:20:23 | speeding | V-040 | D-22 | R-03 | kurzeme | 51.9 | 37.1 |
| 2026-07-16 02:20:23 | gps_ping | V-008 | D-28 | R-13 | latgale | 40.1 | 27.6 |
| 2026-07-16 02:20:23 | gps_ping | V-017 | D-09 | R-11 | vidzeme | 41.9 | 30.3 |
| 2026-07-16 02:20:21 | gps_ping | V-033 | D-22 | R-02 | kurzeme | 33.4 | 23 |
| 2026-07-16 02:20:16 | refuel | V-034 | D-16 | R-05 | riga | 0 | 29.9 |
| 2026-07-16 02:20:13 | speeding | V-016 | D-30 | R-02 | kurzeme | 84 | 29.2 |
| 2026-07-16 02:20:10 | gps_ping | V-048 | D-29 | R-10 | latgale | 77.7 | 27.3 |
| 2026-07-16 02:20:09 | gps_ping | V-008 | D-20 | R-01 | kurzeme | 31.1 | 28.1 |
| 2026-07-16 02:20:07 | gps_ping | V-033 | D-04 | R-12 | kurzeme | 36.5 | 30.3 |
| 2026-07-16 02:20:06 | gps_ping | V-036 | D-08 | R-15 | riga | 67.6 | 29.1 |
| 2026-07-16 02:20:05 | gps_ping | V-028 | D-16 | R-04 | vidzeme | 68.5 | 38.3 |
| 2026-07-16 02:20:04 | gps_ping | V-007 | D-25 | R-07 | riga | 45.8 | 17.2 |
| 2026-07-16 02:20:03 | gps_ping | V-008 | D-21 | R-06 | vidzeme | 80.7 | 28.2 |
| 2026-07-16 02:20:03 | gps_ping | V-026 | D-18 | R-13 | latgale | 44.6 | 11.5 |
| 2026-07-16 02:19:56 | gps_ping | V-037 | D-13 | R-02 | kurzeme | 78.6 | 38.4 |
| 2026-07-16 02:19:55 | gps_ping | V-038 | D-30 | R-01 | kurzeme | 50.6 | 30.9 |
| 2026-07-16 02:19:51 | trip_start | V-002 | D-06 | R-08 | latgale | 37.4 | 33 |
| 2026-07-16 02:19:49 | gps_ping | V-033 | D-06 | R-12 | kurzeme | 35.8 | 27.7 |
| 2026-07-16 02:19:48 | gps_ping | V-002 | D-03 | R-05 | riga | 83.5 | 30.8 |
| 2026-07-16 02:19:48 | gps_ping | V-035 | D-05 | R-07 | riga | 46.2 | 28.9 |
| 2026-07-16 02:19:48 | speeding | V-022 | D-26 | R-08 | latgale | 49.8 | 27.6 |
| 2026-07-16 02:19:48 | engine_fault | V-036 | D-05 | R-09 | riga | 43.9 | 26.6 |
| 2026-07-16 02:19:36 | gps_ping | V-001 | D-20 | R-06 | vidzeme | 82.3 | 31 |
| 2026-07-16 02:19:35 | gps_ping | V-011 | D-04 | R-03 | kurzeme | 59.1 | 14.8 |
| 2026-07-16 02:19:33 | gps_ping | V-010 | D-26 | R-12 | kurzeme | 27.6 | 27.9 |
| 2026-07-16 02:19:24 | gps_ping | V-027 | D-22 | R-02 | kurzeme | 32.2 | 26.8 |
| 2026-07-16 02:19:24 | speeding | V-015 | D-25 | R-12 | kurzeme | 36.7 | 25.3 |
| 2026-07-16 02:19:23 | gps_ping | V-049 | D-17 | R-13 | latgale | 58.7 | 35.1 |
| 2026-07-16 02:19:14 | gps_ping | V-005 | D-04 | R-07 | riga | 37.6 | 16 |