События (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:03:12 | gps_ping | V-028 | D-10 | R-05 | riga | 30.5 | 33.9 |
| 2026-07-16 02:03:12 | speeding | V-026 | D-05 | R-01 | kurzeme | 69.8 | 15.8 |
| 2026-07-16 02:03:07 | gps_ping | V-012 | D-20 | R-04 | vidzeme | 47.1 | 31.6 |
| 2026-07-16 02:02:58 | speeding | V-010 | D-27 | R-07 | riga | 67.7 | 28 |
| 2026-07-16 02:02:57 | gps_ping | V-030 | D-18 | R-14 | latgale | 23.4 | 13.1 |
| 2026-07-16 02:02:55 | gps_ping | V-005 | D-18 | R-14 | latgale | 83.6 | 13.1 |
| 2026-07-16 02:02:55 | gps_ping | V-041 | D-30 | R-15 | riga | 18.4 | 24.3 |
| 2026-07-16 02:02:52 | trip_start | V-001 | D-03 | R-06 | vidzeme | 51.8 | 31.2 |
| 2026-07-16 02:02:48 | trip_end | V-033 | D-20 | R-12 | kurzeme | 37.2 | 27.7 |
| 2026-07-16 02:02:44 | gps_ping | V-041 | D-16 | R-08 | latgale | 71.2 | 31.9 |
| 2026-07-16 02:02:42 | trip_start | V-018 | D-20 | R-13 | latgale | 58.1 | 18.3 |
| 2026-07-16 02:02:39 | harsh_braking | V-017 | D-18 | R-02 | kurzeme | 23 | 30.9 |
| 2026-07-16 02:02:37 | trip_end | V-013 | D-30 | R-10 | latgale | 47.7 | 15.6 |
| 2026-07-16 02:02:37 | refuel | V-045 | D-02 | R-09 | riga | 0 | 14 |
| 2026-07-16 02:02:36 | gps_ping | V-022 | D-08 | R-12 | kurzeme | 27.4 | 30.3 |
| 2026-07-16 02:02:36 | trip_end | V-021 | D-13 | R-07 | riga | 56.2 | 30.2 |
| 2026-07-16 02:02:33 | engine_fault | V-014 | D-05 | R-08 | latgale | 52 | 36.5 |
| 2026-07-16 02:02:31 | gps_ping | V-040 | D-08 | R-12 | kurzeme | 66.9 | 31.4 |
| 2026-07-16 02:02:30 | trip_start | V-026 | D-09 | R-09 | riga | 38.8 | 13.2 |
| 2026-07-16 02:02:14 | gps_ping | V-007 | D-26 | R-01 | kurzeme | 74.3 | 13.6 |
| 2026-07-16 02:02:14 | gps_ping | V-036 | D-20 | R-10 | latgale | 74.9 | 31.6 |
| 2026-07-16 02:02:12 | gps_ping | V-021 | D-02 | R-03 | kurzeme | 25.1 | 34.7 |
| 2026-07-16 02:02:09 | gps_ping | V-012 | D-21 | R-09 | riga | 69.2 | 34.4 |
| 2026-07-16 02:02:09 | gps_ping | V-046 | D-04 | R-04 | vidzeme | 57.2 | 28.3 |
| 2026-07-16 02:02:08 | speeding | V-050 | D-20 | R-02 | kurzeme | 82.8 | 31.5 |
| 2026-07-16 02:02:02 | refuel | V-022 | D-21 | R-12 | kurzeme | 0 | 26.5 |
| 2026-07-16 02:02:00 | idle | V-002 | D-25 | R-12 | kurzeme | 0 | 39.4 |
| 2026-07-16 02:02:00 | trip_start | V-038 | D-14 | R-09 | riga | 57.4 | 25.9 |
| 2026-07-16 02:01:58 | trip_start | V-045 | D-23 | R-05 | riga | 57 | 15.4 |
| 2026-07-16 02:01:53 | gps_ping | V-022 | D-28 | R-14 | latgale | 44 | 28.7 |
| 2026-07-16 02:01:51 | gps_ping | V-043 | D-12 | R-07 | riga | 99.9 | 28.9 |
| 2026-07-16 02:01:49 | gps_ping | V-010 | D-26 | R-06 | vidzeme | 67.4 | 27.1 |
| 2026-07-16 02:01:48 | gps_ping | V-013 | D-06 | R-04 | vidzeme | 27.1 | 13.2 |
| 2026-07-16 02:01:43 | speeding | V-017 | D-30 | R-14 | latgale | 25.7 | 41.2 |
| 2026-07-16 02:01:38 | refuel | V-044 | D-29 | R-14 | latgale | 0 | 26.2 |
| 2026-07-16 02:01:38 | harsh_braking | V-021 | D-08 | R-04 | vidzeme | 43.9 | 36.9 |
| 2026-07-16 02:01:38 | gps_ping | V-016 | D-05 | R-10 | latgale | 54.4 | 32.5 |
| 2026-07-16 02:01:34 | engine_fault | V-008 | D-02 | R-09 | riga | 60.1 | 28.4 |
| 2026-07-16 02:01:33 | gps_ping | V-001 | D-02 | R-15 | riga | 23.5 | 22.5 |
| 2026-07-16 02:01:32 | gps_ping | V-004 | D-15 | R-04 | vidzeme | 62.5 | 25.6 |
| 2026-07-16 02:01:27 | trip_start | V-037 | D-02 | R-05 | riga | 58.5 | 32.5 |
| 2026-07-16 02:01:26 | gps_ping | V-009 | D-28 | R-15 | riga | 43.9 | 32.1 |
| 2026-07-16 02:01:21 | trip_end | V-030 | D-08 | R-15 | riga | 54.8 | 13 |
| 2026-07-16 02:01:18 | gps_ping | V-005 | D-12 | R-12 | kurzeme | 46.3 | 11.9 |
| 2026-07-16 02:01:15 | engine_fault | V-039 | D-20 | R-12 | kurzeme | 40.1 | 13.5 |
| 2026-07-16 02:01:10 | gps_ping | V-025 | D-04 | R-12 | kurzeme | 50.4 | 28.6 |
| 2026-07-16 02:01:00 | gps_ping | V-033 | D-28 | R-05 | riga | 45.7 | 29.9 |
| 2026-07-16 02:01:00 | gps_ping | V-041 | D-05 | R-15 | riga | 48.4 | 37.7 |
| 2026-07-16 02:00:57 | gps_ping | V-038 | D-25 | R-02 | kurzeme | 52.1 | 27.2 |
| 2026-07-16 02:00:56 | trip_end | V-007 | D-17 | R-15 | riga | 63.8 | 14 |