События (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:38:46 | engine_fault | V-033 | D-08 | R-03 | kurzeme | 76.6 | 31.8 |
| 2026-07-16 02:38:46 | gps_ping | V-034 | D-08 | R-14 | latgale | 72.7 | 28.1 |
| 2026-07-16 02:38:43 | gps_ping | V-031 | D-18 | R-15 | riga | 64.2 | 32.5 |
| 2026-07-16 02:38:42 | trip_start | V-049 | D-28 | R-03 | kurzeme | 41.5 | 47 |
| 2026-07-16 02:38:40 | gps_ping | V-045 | D-11 | R-14 | latgale | 55.1 | 13.5 |
| 2026-07-16 02:38:37 | gps_ping | V-048 | D-24 | R-14 | latgale | 44.2 | 32.6 |
| 2026-07-16 02:38:33 | gps_ping | V-042 | D-03 | R-10 | latgale | 55.8 | 34.2 |
| 2026-07-16 02:38:31 | gps_ping | V-019 | D-26 | R-04 | vidzeme | 52.9 | 26.2 |
| 2026-07-16 02:38:27 | refuel | V-041 | D-03 | R-11 | vidzeme | 0 | 25.2 |
| 2026-07-16 02:38:26 | idle | V-013 | D-20 | R-01 | kurzeme | 0 | 18.1 |
| 2026-07-16 02:38:25 | speeding | V-017 | D-27 | R-14 | latgale | 53.7 | 23.6 |
| 2026-07-16 02:38:17 | gps_ping | V-020 | D-28 | R-09 | riga | 65.8 | 32.1 |
| 2026-07-16 02:38:14 | gps_ping | V-046 | D-19 | R-12 | kurzeme | 65.8 | 29.2 |
| 2026-07-16 02:38:12 | gps_ping | V-005 | D-02 | R-09 | riga | 41.3 | 15.4 |
| 2026-07-16 02:38:11 | refuel | V-039 | D-25 | R-10 | latgale | 0 | 10.4 |
| 2026-07-16 02:38:10 | gps_ping | V-009 | D-12 | R-01 | kurzeme | 37 | 35.1 |
| 2026-07-16 02:38:02 | gps_ping | V-013 | D-14 | R-01 | kurzeme | 36 | 13 |
| 2026-07-16 02:38:02 | gps_ping | V-031 | D-08 | R-10 | latgale | 79.8 | 29.1 |
| 2026-07-16 02:38:01 | engine_fault | V-001 | D-19 | R-12 | kurzeme | 48.2 | 39.6 |
| 2026-07-16 02:37:59 | idle | V-028 | D-15 | R-13 | latgale | 0 | 35.5 |
| 2026-07-16 02:37:59 | harsh_braking | V-011 | D-14 | R-02 | kurzeme | 44.8 | 14.2 |
| 2026-07-16 02:37:57 | gps_ping | V-027 | D-17 | R-04 | vidzeme | 25.6 | 30.8 |
| 2026-07-16 02:37:56 | trip_start | V-024 | D-19 | R-01 | kurzeme | 76.1 | 12.5 |
| 2026-07-16 02:37:55 | harsh_braking | V-046 | D-07 | R-09 | riga | 89.5 | 27.5 |
| 2026-07-16 02:37:54 | idle | V-020 | D-19 | R-10 | latgale | 0 | 40.1 |
| 2026-07-16 02:37:53 | gps_ping | V-038 | D-18 | R-05 | riga | 79.1 | 31.1 |
| 2026-07-16 02:37:51 | trip_end | V-033 | D-16 | R-10 | latgale | 54.6 | 29.7 |
| 2026-07-16 02:37:50 | speeding | V-024 | D-06 | R-12 | kurzeme | 59.2 | 11.3 |
| 2026-07-16 02:37:47 | gps_ping | V-040 | D-12 | R-05 | riga | 40.6 | 39.9 |
| 2026-07-16 02:37:45 | gps_ping | V-004 | D-10 | R-02 | kurzeme | 61 | 30.7 |
| 2026-07-16 02:37:43 | engine_fault | V-035 | D-18 | R-13 | latgale | 32.9 | 33.8 |
| 2026-07-16 02:37:42 | gps_ping | V-043 | D-02 | R-15 | riga | 36.2 | 30.2 |
| 2026-07-16 02:37:41 | gps_ping | V-018 | D-01 | R-14 | latgale | 79.4 | 11.7 |
| 2026-07-16 02:37:40 | gps_ping | V-039 | D-14 | R-12 | kurzeme | 54.1 | 16.5 |
| 2026-07-16 02:37:39 | refuel | V-026 | D-14 | R-03 | kurzeme | 0 | 11.8 |
| 2026-07-16 02:37:38 | idle | V-007 | D-02 | R-07 | riga | 0 | 13.9 |
| 2026-07-16 02:37:34 | harsh_braking | V-005 | D-04 | R-01 | kurzeme | 38.3 | 15.8 |
| 2026-07-16 02:37:33 | gps_ping | V-040 | D-21 | R-04 | vidzeme | 41.6 | 31.4 |
| 2026-07-16 02:37:32 | idle | V-019 | D-03 | R-01 | kurzeme | 0 | 30.3 |
| 2026-07-16 02:37:29 | gps_ping | V-017 | D-17 | R-08 | latgale | 63.2 | 30.9 |
| 2026-07-16 02:37:27 | gps_ping | V-031 | D-30 | R-11 | vidzeme | 22.4 | 28.3 |
| 2026-07-16 02:37:26 | gps_ping | V-033 | D-09 | R-15 | riga | 97.6 | 32 |
| 2026-07-16 02:37:20 | gps_ping | V-030 | D-27 | R-13 | latgale | 76.9 | 14.8 |
| 2026-07-16 02:37:19 | trip_end | V-005 | D-09 | R-10 | latgale | 33.5 | 13.7 |
| 2026-07-16 02:37:13 | gps_ping | V-010 | D-17 | R-13 | latgale | 68.2 | 29 |
| 2026-07-16 02:37:10 | gps_ping | V-013 | D-19 | R-03 | kurzeme | 32.7 | 15.8 |
| 2026-07-16 02:36:58 | gps_ping | V-045 | D-24 | R-05 | riga | 14.6 | 18.4 |
| 2026-07-16 02:36:58 | trip_start | V-048 | D-07 | R-08 | latgale | 53.3 | 25 |
| 2026-07-16 02:36:57 | gps_ping | V-011 | D-02 | R-04 | vidzeme | 36 | 15.1 |
| 2026-07-16 02:36:54 | refuel | V-044 | D-19 | R-04 | vidzeme | 0 | 34.5 |