События (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:14:06 | gps_ping | V-046 | D-09 | R-08 | latgale | 76.1 | 25.1 |
| 2026-07-16 02:14:04 | engine_fault | V-021 | D-23 | R-07 | riga | 79.2 | 37.3 |
| 2026-07-16 02:14:01 | trip_start | V-040 | D-08 | R-09 | riga | 76.8 | 29.7 |
| 2026-07-16 02:13:56 | trip_end | V-037 | D-16 | R-06 | vidzeme | 54.3 | 33.3 |
| 2026-07-16 02:13:51 | harsh_braking | V-010 | D-28 | R-08 | latgale | 34.9 | 32.2 |
| 2026-07-16 02:13:47 | refuel | V-005 | D-26 | R-02 | kurzeme | 0 | 16.4 |
| 2026-07-16 02:13:47 | trip_end | V-017 | D-21 | R-10 | latgale | 83.8 | 29 |
| 2026-07-16 02:13:44 | gps_ping | V-017 | D-08 | R-03 | kurzeme | 42.2 | 26.8 |
| 2026-07-16 02:13:43 | gps_ping | V-024 | D-26 | R-09 | riga | 91.2 | 15.3 |
| 2026-07-16 02:13:40 | gps_ping | V-012 | D-17 | R-15 | riga | 84.6 | 30.4 |
| 2026-07-16 02:13:39 | gps_ping | V-002 | D-24 | R-14 | latgale | 31.6 | 31.1 |
| 2026-07-16 02:13:39 | gps_ping | V-020 | D-08 | R-09 | riga | 75.8 | 26.5 |
| 2026-07-16 02:13:38 | gps_ping | V-028 | D-19 | R-01 | kurzeme | 56.4 | 35.1 |
| 2026-07-16 02:13:36 | gps_ping | V-026 | D-30 | R-10 | latgale | 100.7 | 12.1 |
| 2026-07-16 02:13:36 | trip_start | V-026 | D-06 | R-07 | riga | 34.6 | 13.9 |
| 2026-07-16 02:13:33 | gps_ping | V-012 | D-02 | R-10 | latgale | 32.5 | 26.8 |
| 2026-07-16 02:13:32 | gps_ping | V-003 | D-25 | R-12 | kurzeme | 87.1 | 30 |
| 2026-07-16 02:13:30 | gps_ping | V-041 | D-21 | R-13 | latgale | 84.8 | 24.7 |
| 2026-07-16 02:13:26 | gps_ping | V-009 | D-22 | R-14 | latgale | 37.7 | 33.2 |
| 2026-07-16 02:13:24 | gps_ping | V-041 | D-16 | R-02 | kurzeme | 41.8 | 30.7 |
| 2026-07-16 02:13:20 | trip_start | V-044 | D-24 | R-09 | riga | 44.5 | 28.3 |
| 2026-07-16 02:13:19 | refuel | V-045 | D-07 | R-13 | latgale | 0 | 13.7 |
| 2026-07-16 02:13:15 | gps_ping | V-044 | D-26 | R-01 | kurzeme | 48.8 | 29.4 |
| 2026-07-16 02:13:14 | gps_ping | V-010 | D-26 | R-02 | kurzeme | 45 | 27.8 |
| 2026-07-16 02:13:13 | trip_end | V-041 | D-01 | R-11 | vidzeme | 75.5 | 25.6 |
| 2026-07-16 02:13:12 | gps_ping | V-031 | D-15 | R-01 | kurzeme | 69.1 | 25.7 |
| 2026-07-16 02:13:11 | trip_end | V-022 | D-18 | R-07 | riga | 55.4 | 27.4 |
| 2026-07-16 02:13:08 | gps_ping | V-012 | D-09 | R-02 | kurzeme | 48.9 | 30 |
| 2026-07-16 02:13:08 | gps_ping | V-049 | D-06 | R-08 | latgale | 30.8 | 30.5 |
| 2026-07-16 02:13:07 | harsh_braking | V-004 | D-01 | R-15 | riga | 26.3 | 31.1 |
| 2026-07-16 02:13:06 | trip_start | V-018 | D-26 | R-01 | kurzeme | 67.2 | 13.1 |
| 2026-07-16 02:12:58 | gps_ping | V-049 | D-03 | R-11 | vidzeme | 51 | 31.4 |
| 2026-07-16 02:12:58 | gps_ping | V-020 | D-12 | R-03 | kurzeme | 84.8 | 32.8 |
| 2026-07-16 02:12:55 | trip_end | V-038 | D-17 | R-13 | latgale | 98.1 | 31.7 |
| 2026-07-16 02:12:54 | gps_ping | V-012 | D-05 | R-01 | kurzeme | 77.4 | 25.2 |
| 2026-07-16 02:12:51 | idle | V-006 | D-11 | R-09 | riga | 0 | 29.4 |
| 2026-07-16 02:12:50 | gps_ping | V-020 | D-09 | R-06 | vidzeme | 54.3 | 25.6 |
| 2026-07-16 02:12:49 | refuel | V-047 | D-06 | R-02 | kurzeme | 0 | 15 |
| 2026-07-16 02:12:48 | gps_ping | V-014 | D-26 | R-15 | riga | 42.6 | 33.6 |
| 2026-07-16 02:12:42 | speeding | V-002 | D-10 | R-11 | vidzeme | 80.1 | 35.3 |
| 2026-07-16 02:12:36 | gps_ping | V-039 | D-03 | R-11 | vidzeme | 39.7 | 13.9 |
| 2026-07-16 02:12:36 | gps_ping | V-036 | D-14 | R-02 | kurzeme | 83.9 | 27.3 |
| 2026-07-16 02:12:35 | refuel | V-027 | D-13 | R-12 | kurzeme | 0 | 28.4 |
| 2026-07-16 02:12:34 | gps_ping | V-039 | D-23 | R-12 | kurzeme | 26.5 | 9.9 |
| 2026-07-16 02:12:28 | gps_ping | V-038 | D-28 | R-15 | riga | 33.2 | 24.3 |
| 2026-07-16 02:12:23 | gps_ping | V-014 | D-19 | R-08 | latgale | 69.7 | 31.3 |
| 2026-07-16 02:12:22 | gps_ping | V-050 | D-20 | R-14 | latgale | 89.8 | 29.6 |
| 2026-07-16 02:12:22 | trip_start | V-046 | D-02 | R-15 | riga | 74.9 | 28.9 |
| 2026-07-16 02:12:17 | gps_ping | V-039 | D-09 | R-09 | riga | 50 | 16.2 |
| 2026-07-16 02:12:07 | gps_ping | V-048 | D-20 | R-12 | kurzeme | 62.2 | 29 |