События (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:40:53 | gps_ping | V-043 | D-04 | R-09 | riga | 83.2 | 25.9 |
| 2026-07-16 01:40:52 | gps_ping | V-028 | D-18 | R-04 | vidzeme | 38 | 32.8 |
| 2026-07-16 01:40:48 | gps_ping | V-044 | D-21 | R-14 | latgale | 50.9 | 27.7 |
| 2026-07-16 01:40:41 | gps_ping | V-029 | D-16 | R-09 | riga | 63.5 | 32.1 |
| 2026-07-16 01:40:40 | trip_end | V-026 | D-22 | R-07 | riga | 53.9 | 13.1 |
| 2026-07-16 01:40:37 | gps_ping | V-035 | D-19 | R-14 | latgale | 42.5 | 28.2 |
| 2026-07-16 01:40:33 | gps_ping | V-044 | D-30 | R-09 | riga | 20.1 | 31.4 |
| 2026-07-16 01:40:28 | trip_start | V-003 | D-26 | R-05 | riga | 63.9 | 28.3 |
| 2026-07-16 01:40:27 | gps_ping | V-008 | D-11 | R-04 | vidzeme | 31.1 | 27.9 |
| 2026-07-16 01:40:25 | gps_ping | V-018 | D-10 | R-07 | riga | 46.5 | 13.4 |
| 2026-07-16 01:40:25 | gps_ping | V-037 | D-22 | R-11 | vidzeme | 77.1 | 30.7 |
| 2026-07-16 01:40:17 | idle | V-013 | D-07 | R-02 | kurzeme | 0 | 12.1 |
| 2026-07-16 01:40:15 | gps_ping | V-043 | D-11 | R-14 | latgale | 79.3 | 34.3 |
| 2026-07-16 01:40:14 | gps_ping | V-035 | D-13 | R-03 | kurzeme | 108.5 | 26.7 |
| 2026-07-16 01:40:13 | gps_ping | V-014 | D-07 | R-04 | vidzeme | 43.2 | 37.6 |
| 2026-07-16 01:40:11 | gps_ping | V-007 | D-27 | R-09 | riga | 55.6 | 18.7 |
| 2026-07-16 01:40:09 | engine_fault | V-018 | D-09 | R-06 | vidzeme | 69.4 | 10.9 |
| 2026-07-16 01:40:09 | gps_ping | V-030 | D-28 | R-09 | riga | 96.7 | 12.2 |
| 2026-07-16 01:40:04 | gps_ping | V-049 | D-05 | R-03 | kurzeme | 77.3 | 38.9 |
| 2026-07-16 01:40:04 | gps_ping | V-046 | D-19 | R-04 | vidzeme | 56.8 | 22.9 |
| 2026-07-16 01:40:00 | gps_ping | V-016 | D-08 | R-12 | kurzeme | 83.7 | 36 |
| 2026-07-16 01:39:56 | refuel | V-008 | D-11 | R-10 | latgale | 0 | 29.7 |
| 2026-07-16 01:39:56 | gps_ping | V-026 | D-17 | R-08 | latgale | 72 | 13.2 |
| 2026-07-16 01:39:48 | gps_ping | V-004 | D-03 | R-15 | riga | 58.2 | 29.9 |
| 2026-07-16 01:39:46 | trip_end | V-024 | D-13 | R-05 | riga | 37.9 | 14.3 |
| 2026-07-16 01:39:46 | engine_fault | V-006 | D-24 | R-14 | latgale | 31.4 | 28.1 |
| 2026-07-16 01:39:46 | gps_ping | V-017 | D-09 | R-02 | kurzeme | 24.5 | 30.3 |
| 2026-07-16 01:39:42 | gps_ping | V-018 | D-12 | R-10 | latgale | 72.1 | 15.2 |
| 2026-07-16 01:39:40 | harsh_braking | V-037 | D-09 | R-07 | riga | 30.8 | 29.1 |
| 2026-07-16 01:39:36 | gps_ping | V-041 | D-02 | R-11 | vidzeme | 92.9 | 27 |
| 2026-07-16 01:39:35 | gps_ping | V-034 | D-15 | R-02 | kurzeme | 47.9 | 31.8 |
| 2026-07-16 01:39:35 | gps_ping | V-003 | D-24 | R-13 | latgale | 79.3 | 26.5 |
| 2026-07-16 01:39:33 | gps_ping | V-004 | D-22 | R-07 | riga | 24.7 | 32.3 |
| 2026-07-16 01:39:33 | gps_ping | V-010 | D-08 | R-13 | latgale | 105.9 | 30.6 |
| 2026-07-16 01:39:32 | harsh_braking | V-007 | D-17 | R-06 | vidzeme | 67.8 | 14.5 |
| 2026-07-16 01:39:31 | trip_end | V-047 | D-20 | R-15 | riga | 75.9 | 15.7 |
| 2026-07-16 01:39:27 | gps_ping | V-025 | D-16 | R-09 | riga | 79 | 35.2 |
| 2026-07-16 01:39:26 | gps_ping | V-036 | D-04 | R-06 | vidzeme | 61.3 | 29.2 |
| 2026-07-16 01:39:24 | gps_ping | V-041 | D-09 | R-10 | latgale | 51.4 | 25.2 |
| 2026-07-16 01:39:20 | gps_ping | V-035 | D-05 | R-15 | riga | 39.9 | 33.1 |
| 2026-07-16 01:39:09 | trip_end | V-033 | D-14 | R-01 | kurzeme | 74.5 | 26.9 |
| 2026-07-16 01:39:04 | gps_ping | V-050 | D-27 | R-03 | kurzeme | 47.4 | 32.4 |
| 2026-07-16 01:39:02 | speeding | V-044 | D-27 | R-05 | riga | 39.1 | 28.6 |
| 2026-07-16 01:39:01 | refuel | V-011 | D-28 | R-09 | riga | 0 | 11.9 |
| 2026-07-16 01:39:00 | gps_ping | V-018 | D-25 | R-11 | vidzeme | 69.9 | 12.6 |
| 2026-07-16 01:38:57 | gps_ping | V-042 | D-02 | R-08 | latgale | 74.1 | 30 |
| 2026-07-16 01:38:56 | gps_ping | V-028 | D-18 | R-03 | kurzeme | 30.2 | 31.8 |
| 2026-07-16 01:38:55 | gps_ping | V-042 | D-30 | R-14 | latgale | 79.2 | 32.3 |
| 2026-07-16 01:38:55 | trip_start | V-018 | D-17 | R-02 | kurzeme | 72.7 | 15.7 |
| 2026-07-16 01:38:51 | gps_ping | V-035 | D-21 | R-07 | riga | 35.5 | 33 |