События (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:19:14 | gps_ping | V-005 | D-04 | R-07 | riga | 37.6 | 16 |
| 2026-07-16 02:19:12 | trip_end | V-021 | D-16 | R-12 | kurzeme | 24.6 | 34.2 |
| 2026-07-16 02:19:11 | engine_fault | V-045 | D-23 | R-13 | latgale | 40.7 | 15.4 |
| 2026-07-16 02:19:07 | trip_start | V-043 | D-17 | R-09 | riga | 81.9 | 28.1 |
| 2026-07-16 02:19:02 | gps_ping | V-006 | D-08 | R-02 | kurzeme | 56 | 27.4 |
| 2026-07-16 02:19:01 | engine_fault | V-030 | D-24 | R-08 | latgale | 84.6 | 11.9 |
| 2026-07-16 02:18:56 | gps_ping | V-031 | D-20 | R-15 | riga | 54.9 | 24.8 |
| 2026-07-16 02:18:56 | gps_ping | V-033 | D-29 | R-12 | kurzeme | 49.3 | 26.2 |
| 2026-07-16 02:18:55 | gps_ping | V-001 | D-28 | R-05 | riga | 39.1 | 26.1 |
| 2026-07-16 02:18:53 | harsh_braking | V-018 | D-12 | R-12 | kurzeme | 38.1 | 13 |
| 2026-07-16 02:18:52 | gps_ping | V-022 | D-05 | R-04 | vidzeme | 59.2 | 27.7 |
| 2026-07-16 02:18:52 | gps_ping | V-043 | D-06 | R-07 | riga | 82.3 | 28.7 |
| 2026-07-16 02:18:51 | gps_ping | V-011 | D-25 | R-01 | kurzeme | 77.9 | 16.3 |
| 2026-07-16 02:18:51 | gps_ping | V-012 | D-07 | R-14 | latgale | 56.5 | 29.5 |
| 2026-07-16 02:18:49 | gps_ping | V-022 | D-11 | R-08 | latgale | 40.3 | 23.8 |
| 2026-07-16 02:18:43 | gps_ping | V-002 | D-26 | R-07 | riga | 75.2 | 36.1 |
| 2026-07-16 02:18:43 | harsh_braking | V-043 | D-30 | R-13 | latgale | 73.5 | 26.8 |
| 2026-07-16 02:18:41 | trip_start | V-034 | D-08 | R-09 | riga | 43.7 | 29.5 |
| 2026-07-16 02:18:39 | engine_fault | V-017 | D-14 | R-02 | kurzeme | 62.8 | 29.7 |
| 2026-07-16 02:18:38 | gps_ping | V-034 | D-28 | R-14 | latgale | 68.9 | 26 |
| 2026-07-16 02:18:35 | refuel | V-049 | D-11 | R-03 | kurzeme | 0 | 33.5 |
| 2026-07-16 02:18:35 | harsh_braking | V-007 | D-12 | R-04 | vidzeme | 31.9 | 13.6 |
| 2026-07-16 02:18:33 | refuel | V-021 | D-14 | R-08 | latgale | 0 | 32.7 |
| 2026-07-16 02:18:29 | gps_ping | V-025 | D-08 | R-12 | kurzeme | 43.1 | 24.8 |
| 2026-07-16 02:18:28 | gps_ping | V-033 | D-17 | R-07 | riga | 32.5 | 36.3 |
| 2026-07-16 02:18:28 | gps_ping | V-037 | D-02 | R-05 | riga | 53.1 | 36.8 |
| 2026-07-16 02:18:27 | gps_ping | V-039 | D-07 | R-02 | kurzeme | 31.7 | 13.5 |
| 2026-07-16 02:18:27 | gps_ping | V-046 | D-02 | R-11 | vidzeme | 53.8 | 30.1 |
| 2026-07-16 02:18:25 | gps_ping | V-034 | D-08 | R-11 | vidzeme | 65.3 | 27.6 |
| 2026-07-16 02:18:22 | gps_ping | V-006 | D-22 | R-10 | latgale | 40.8 | 25.2 |
| 2026-07-16 02:18:21 | trip_start | V-007 | D-29 | R-01 | kurzeme | 57.9 | 11.1 |
| 2026-07-16 02:18:19 | idle | V-029 | D-26 | R-12 | kurzeme | 0 | 29 |
| 2026-07-16 02:18:17 | gps_ping | V-043 | D-28 | R-14 | latgale | 82.9 | 28.5 |
| 2026-07-16 02:18:16 | trip_end | V-018 | D-01 | R-06 | vidzeme | 74.6 | 13.6 |
| 2026-07-16 02:18:14 | gps_ping | V-009 | D-21 | R-15 | riga | 61.5 | 34.9 |
| 2026-07-16 02:18:12 | harsh_braking | V-030 | D-25 | R-07 | riga | 75.1 | 17.5 |
| 2026-07-16 02:18:08 | gps_ping | V-016 | D-10 | R-11 | vidzeme | 32.8 | 32.4 |
| 2026-07-16 02:17:59 | gps_ping | V-025 | D-25 | R-13 | latgale | 36.8 | 31.6 |
| 2026-07-16 02:17:55 | trip_start | V-016 | D-26 | R-12 | kurzeme | 69.5 | 45 |
| 2026-07-16 02:17:55 | trip_end | V-001 | D-12 | R-06 | vidzeme | 61.4 | 27 |
| 2026-07-16 02:17:54 | harsh_braking | V-031 | D-30 | R-12 | kurzeme | 52.8 | 21.7 |
| 2026-07-16 02:17:54 | engine_fault | V-012 | D-20 | R-14 | latgale | 44.2 | 28.9 |
| 2026-07-16 02:17:53 | gps_ping | V-024 | D-24 | R-12 | kurzeme | 47.8 | 15.1 |
| 2026-07-16 02:17:53 | gps_ping | V-013 | D-08 | R-08 | latgale | 73.9 | 12.2 |
| 2026-07-16 02:17:53 | gps_ping | V-014 | D-02 | R-01 | kurzeme | 23.3 | 30.3 |
| 2026-07-16 02:17:51 | gps_ping | V-011 | D-11 | R-02 | kurzeme | 29.9 | 13.5 |
| 2026-07-16 02:17:50 | gps_ping | V-013 | D-24 | R-03 | kurzeme | 36.2 | 12.7 |
| 2026-07-16 02:17:49 | gps_ping | V-010 | D-18 | R-01 | kurzeme | 45.3 | 29.3 |
| 2026-07-16 02:17:47 | gps_ping | V-010 | D-18 | R-07 | riga | 60.2 | 27.6 |
| 2026-07-16 02:17:46 | gps_ping | V-010 | D-14 | R-02 | kurzeme | 79.4 | 22 |