События (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:04:40 | idle | V-017 | D-07 | R-03 | kurzeme | 0 | 30.2 |
| 2026-07-16 01:04:37 | trip_end | V-042 | D-01 | R-15 | riga | 12.5 | 36.9 |
| 2026-07-16 01:04:36 | gps_ping | V-003 | D-17 | R-09 | riga | 34.8 | 28.8 |
| 2026-07-16 01:04:34 | engine_fault | V-019 | D-15 | R-04 | vidzeme | 41.5 | 25.5 |
| 2026-07-16 01:04:32 | gps_ping | V-003 | D-29 | R-13 | latgale | 71.9 | 32.6 |
| 2026-07-16 01:04:26 | trip_end | V-012 | D-23 | R-13 | latgale | 74.6 | 35.7 |
| 2026-07-16 01:04:25 | gps_ping | V-009 | D-04 | R-07 | riga | 54.1 | 28.1 |
| 2026-07-16 01:04:24 | gps_ping | V-010 | D-09 | R-12 | kurzeme | 78.4 | 31.7 |
| 2026-07-16 01:04:19 | idle | V-022 | D-04 | R-01 | kurzeme | 0 | 24.1 |
| 2026-07-16 01:04:17 | engine_fault | V-046 | D-16 | R-08 | latgale | 57.6 | 33.6 |
| 2026-07-16 01:04:13 | speeding | V-042 | D-14 | R-05 | riga | 69.4 | 34.9 |
| 2026-07-16 01:04:11 | trip_end | V-022 | D-13 | R-11 | vidzeme | 97.6 | 34.7 |
| 2026-07-16 01:04:02 | gps_ping | V-049 | D-04 | R-12 | kurzeme | 31.8 | 34.8 |
| 2026-07-16 01:03:59 | gps_ping | V-014 | D-24 | R-04 | vidzeme | 18.1 | 32.6 |
| 2026-07-16 01:03:56 | trip_end | V-008 | D-09 | R-14 | latgale | 44.1 | 27.9 |
| 2026-07-16 01:03:56 | gps_ping | V-039 | D-04 | R-12 | kurzeme | 63.2 | 15 |
| 2026-07-16 01:03:54 | speeding | V-001 | D-07 | R-07 | riga | 60.8 | 34.6 |
| 2026-07-16 01:03:51 | trip_end | V-028 | D-11 | R-07 | riga | 79.3 | 33.1 |
| 2026-07-16 01:03:51 | gps_ping | V-042 | D-02 | R-14 | latgale | 38.1 | 32.4 |
| 2026-07-16 01:03:44 | gps_ping | V-012 | D-16 | R-07 | riga | 35.4 | 24.8 |
| 2026-07-16 01:03:36 | gps_ping | V-041 | D-02 | R-10 | latgale | 31.3 | 29.9 |
| 2026-07-16 01:03:32 | harsh_braking | V-028 | D-25 | R-07 | riga | 78.4 | 32.9 |
| 2026-07-16 01:03:27 | trip_end | V-017 | D-29 | R-10 | latgale | 76 | 24.4 |
| 2026-07-16 01:03:26 | speeding | V-019 | D-19 | R-03 | kurzeme | 52.5 | 26.8 |
| 2026-07-16 01:03:24 | gps_ping | V-021 | D-27 | R-03 | kurzeme | 83.9 | 31.4 |
| 2026-07-16 01:03:21 | gps_ping | V-020 | D-01 | R-15 | riga | 43.1 | 29.2 |
| 2026-07-16 01:03:19 | gps_ping | V-012 | D-17 | R-09 | riga | 85.8 | 28.3 |
| 2026-07-16 01:03:08 | idle | V-027 | D-07 | R-04 | vidzeme | 0 | 28.8 |
| 2026-07-16 01:03:05 | engine_fault | V-039 | D-08 | R-13 | latgale | 40.4 | 13.2 |
| 2026-07-16 01:03:03 | idle | V-017 | D-17 | R-07 | riga | 0 | 32.9 |
| 2026-07-16 01:03:02 | gps_ping | V-043 | D-20 | R-07 | riga | 56.3 | 32.2 |
| 2026-07-16 01:02:55 | harsh_braking | V-032 | D-09 | R-14 | latgale | 57.7 | 14.2 |
| 2026-07-16 01:02:52 | trip_end | V-007 | D-02 | R-01 | kurzeme | 81.5 | 16.3 |
| 2026-07-16 01:02:50 | gps_ping | V-029 | D-19 | R-07 | riga | 90 | 29.5 |
| 2026-07-16 01:02:46 | gps_ping | V-031 | D-18 | R-08 | latgale | 66.7 | 31.2 |
| 2026-07-16 01:02:44 | speeding | V-026 | D-09 | R-03 | kurzeme | 28.8 | 16.1 |
| 2026-07-16 01:02:40 | gps_ping | V-029 | D-05 | R-15 | riga | 41 | 28.7 |
| 2026-07-16 01:02:32 | gps_ping | V-017 | D-20 | R-08 | latgale | 35.5 | 27.5 |
| 2026-07-16 01:02:23 | trip_start | V-015 | D-13 | R-01 | kurzeme | 87.9 | 29.2 |
| 2026-07-16 01:02:16 | gps_ping | V-025 | D-10 | R-09 | riga | 30.7 | 26.3 |
| 2026-07-16 01:02:15 | gps_ping | V-034 | D-20 | R-09 | riga | 67 | 25.5 |
| 2026-07-16 01:02:10 | trip_start | V-017 | D-23 | R-07 | riga | 24 | 25.3 |
| 2026-07-16 01:02:10 | trip_end | V-038 | D-02 | R-07 | riga | 63.4 | 27.1 |
| 2026-07-16 01:02:08 | engine_fault | V-034 | D-13 | R-02 | kurzeme | 80.9 | 26.8 |
| 2026-07-16 01:02:06 | trip_end | V-046 | D-13 | R-12 | kurzeme | 37.4 | 30.9 |
| 2026-07-16 01:02:06 | gps_ping | V-039 | D-22 | R-06 | vidzeme | 59 | 15 |
| 2026-07-16 01:02:03 | gps_ping | V-026 | D-06 | R-02 | kurzeme | 78.1 | 18.4 |
| 2026-07-16 01:02:01 | gps_ping | V-025 | D-10 | R-06 | vidzeme | 39.4 | 26.2 |
| 2026-07-16 01:02:00 | gps_ping | V-046 | D-17 | R-14 | latgale | 57.1 | 28.8 |
| 2026-07-16 01:01:53 | refuel | V-037 | D-23 | R-14 | latgale | 0 | 30.4 |