События (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:34:09 | gps_ping | V-010 | D-15 | R-06 | vidzeme | 63.1 | 23.8 |
| 2026-07-16 01:34:07 | gps_ping | V-029 | D-27 | R-10 | latgale | 81.3 | 28.5 |
| 2026-07-16 01:34:06 | refuel | V-008 | D-19 | R-10 | latgale | 0 | 31.1 |
| 2026-07-16 01:34:06 | gps_ping | V-010 | D-20 | R-12 | kurzeme | 26 | 26.2 |
| 2026-07-16 01:34:04 | gps_ping | V-047 | D-11 | R-13 | latgale | 18.6 | 17.1 |
| 2026-07-16 01:34:02 | gps_ping | V-033 | D-20 | R-02 | kurzeme | 34.6 | 21.3 |
| 2026-07-16 01:34:02 | gps_ping | V-045 | D-30 | R-05 | riga | 70.2 | 17 |
| 2026-07-16 01:34:01 | harsh_braking | V-006 | D-13 | R-10 | latgale | 67.8 | 35.3 |
| 2026-07-16 01:34:01 | trip_end | V-024 | D-12 | R-12 | kurzeme | 79 | 14.7 |
| 2026-07-16 01:33:54 | gps_ping | V-006 | D-12 | R-06 | vidzeme | 83.5 | 32.2 |
| 2026-07-16 01:33:41 | gps_ping | V-030 | D-14 | R-10 | latgale | 58.3 | 15.4 |
| 2026-07-16 01:33:41 | gps_ping | V-048 | D-30 | R-10 | latgale | 77.8 | 30.6 |
| 2026-07-16 01:33:39 | gps_ping | V-018 | D-12 | R-10 | latgale | 25.5 | 13.9 |
| 2026-07-16 01:33:37 | gps_ping | V-035 | D-29 | R-08 | latgale | 55.8 | 33.4 |
| 2026-07-16 01:33:36 | engine_fault | V-033 | D-13 | R-12 | kurzeme | 35.7 | 24.5 |
| 2026-07-16 01:33:36 | gps_ping | V-020 | D-06 | R-12 | kurzeme | 79.5 | 29.8 |
| 2026-07-16 01:33:36 | trip_start | V-027 | D-06 | R-09 | riga | 31.6 | 29.8 |
| 2026-07-16 01:33:33 | gps_ping | V-045 | D-05 | R-01 | kurzeme | 63.6 | 10 |
| 2026-07-16 01:33:32 | trip_end | V-004 | D-20 | R-08 | latgale | 40.9 | 36 |
| 2026-07-16 01:33:30 | refuel | V-019 | D-17 | R-14 | latgale | 0 | 30.7 |
| 2026-07-16 01:33:30 | gps_ping | V-024 | D-26 | R-10 | latgale | 14.8 | 12.2 |
| 2026-07-16 01:33:29 | gps_ping | V-032 | D-04 | R-07 | riga | 85.2 | 18.4 |
| 2026-07-16 01:33:25 | gps_ping | V-018 | D-21 | R-14 | latgale | 68.9 | 18.8 |
| 2026-07-16 01:33:24 | speeding | V-045 | D-04 | R-14 | latgale | 74.5 | 11.7 |
| 2026-07-16 01:33:17 | gps_ping | V-032 | D-17 | R-14 | latgale | 81.7 | 9.2 |
| 2026-07-16 01:33:16 | harsh_braking | V-049 | D-21 | R-06 | vidzeme | 35.8 | 32.6 |
| 2026-07-16 01:33:16 | gps_ping | V-015 | D-19 | R-07 | riga | 84.4 | 23.5 |
| 2026-07-16 01:33:16 | idle | V-030 | D-02 | R-06 | vidzeme | 0 | 13.2 |
| 2026-07-16 01:33:15 | harsh_braking | V-020 | D-28 | R-04 | vidzeme | 25.9 | 26.8 |
| 2026-07-16 01:33:14 | trip_start | V-037 | D-29 | R-13 | latgale | 31.7 | 38.9 |
| 2026-07-16 01:33:13 | gps_ping | V-010 | D-30 | R-06 | vidzeme | 27.9 | 25.3 |
| 2026-07-16 01:33:09 | gps_ping | V-018 | D-24 | R-05 | riga | 39.4 | 14.9 |
| 2026-07-16 01:33:03 | gps_ping | V-042 | D-12 | R-14 | latgale | 68.6 | 36.2 |
| 2026-07-16 01:32:56 | gps_ping | V-029 | D-01 | R-05 | riga | 70.1 | 26.7 |
| 2026-07-16 01:32:54 | gps_ping | V-028 | D-25 | R-15 | riga | 73.4 | 34.7 |
| 2026-07-16 01:32:54 | trip_start | V-020 | D-07 | R-08 | latgale | 76.7 | 30.2 |
| 2026-07-16 01:32:52 | gps_ping | V-004 | D-11 | R-15 | riga | 79.1 | 25.2 |
| 2026-07-16 01:32:45 | gps_ping | V-019 | D-02 | R-02 | kurzeme | 75.7 | 30.5 |
| 2026-07-16 01:32:31 | trip_end | V-050 | D-02 | R-15 | riga | 52.9 | 30.6 |
| 2026-07-16 01:32:31 | refuel | V-004 | D-24 | R-09 | riga | 0 | 27.2 |
| 2026-07-16 01:32:28 | gps_ping | V-014 | D-01 | R-11 | vidzeme | 26.5 | 33.8 |
| 2026-07-16 01:32:27 | trip_start | V-017 | D-01 | R-01 | kurzeme | 44.4 | 27.4 |
| 2026-07-16 01:32:25 | gps_ping | V-041 | D-27 | R-07 | riga | 43.9 | 30.1 |
| 2026-07-16 01:32:22 | trip_end | V-026 | D-29 | R-15 | riga | 56.3 | 17.3 |
| 2026-07-16 01:32:17 | gps_ping | V-046 | D-03 | R-10 | latgale | 68.1 | 29.7 |
| 2026-07-16 01:32:17 | idle | V-044 | D-30 | R-12 | kurzeme | 0 | 26.1 |
| 2026-07-16 01:32:15 | trip_start | V-045 | D-16 | R-14 | latgale | 32.9 | 13.3 |
| 2026-07-16 01:32:14 | idle | V-048 | D-14 | R-01 | kurzeme | 0 | 29.9 |
| 2026-07-16 01:32:12 | gps_ping | V-038 | D-07 | R-01 | kurzeme | 32.4 | 32.3 |
| 2026-07-16 01:32:11 | gps_ping | V-005 | D-21 | R-11 | vidzeme | 41.1 | 14.2 |