События (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:44:33 | gps_ping | V-047 | D-14 | R-09 | riga | 52.2 | 14.7 |
| 2026-07-16 02:44:31 | gps_ping | V-028 | D-20 | R-06 | vidzeme | 62.3 | 30.2 |
| 2026-07-16 02:44:31 | gps_ping | V-016 | D-01 | R-10 | latgale | 74.5 | 36 |
| 2026-07-16 02:44:24 | gps_ping | V-011 | D-29 | R-12 | kurzeme | 49.1 | 14.7 |
| 2026-07-16 02:44:21 | engine_fault | V-002 | D-05 | R-14 | latgale | 49.7 | 28.5 |
| 2026-07-16 02:44:19 | refuel | V-011 | D-22 | R-15 | riga | 0 | 12.3 |
| 2026-07-16 02:44:14 | engine_fault | V-006 | D-03 | R-06 | vidzeme | 33.2 | 30.1 |
| 2026-07-16 02:44:12 | gps_ping | V-026 | D-26 | R-15 | riga | 53.9 | 17.5 |
| 2026-07-16 02:44:11 | harsh_braking | V-014 | D-07 | R-11 | vidzeme | 78.4 | 36 |
| 2026-07-16 02:44:07 | gps_ping | V-017 | D-06 | R-09 | riga | 80.2 | 30.3 |
| 2026-07-16 02:44:03 | gps_ping | V-008 | D-29 | R-04 | vidzeme | 56.3 | 26.6 |
| 2026-07-16 02:44:03 | gps_ping | V-001 | D-08 | R-15 | riga | 55.7 | 23 |
| 2026-07-16 02:44:03 | gps_ping | V-019 | D-25 | R-13 | latgale | 30.7 | 25.2 |
| 2026-07-16 02:44:02 | idle | V-032 | D-10 | R-14 | latgale | 0 | 12.5 |
| 2026-07-16 02:44:01 | gps_ping | V-043 | D-08 | R-07 | riga | 78.1 | 28.8 |
| 2026-07-16 02:43:55 | gps_ping | V-040 | D-17 | R-05 | riga | 27.5 | 28.8 |
| 2026-07-16 02:43:53 | gps_ping | V-018 | D-27 | R-01 | kurzeme | 94.6 | 16.6 |
| 2026-07-16 02:43:52 | speeding | V-029 | D-18 | R-09 | riga | 76 | 26.3 |
| 2026-07-16 02:43:48 | trip_end | V-006 | D-18 | R-02 | kurzeme | 47.9 | 29.2 |
| 2026-07-16 02:43:46 | gps_ping | V-023 | D-05 | R-04 | vidzeme | 50.2 | 31.3 |
| 2026-07-16 02:43:44 | gps_ping | V-046 | D-21 | R-09 | riga | 25.6 | 28.2 |
| 2026-07-16 02:43:42 | trip_start | V-032 | D-23 | R-09 | riga | 57.8 | 10.9 |
| 2026-07-16 02:43:40 | harsh_braking | V-006 | D-21 | R-08 | latgale | 33.4 | 26 |
| 2026-07-16 02:43:37 | harsh_braking | V-047 | D-06 | R-04 | vidzeme | 49.2 | 14.5 |
| 2026-07-16 02:43:36 | gps_ping | V-042 | D-05 | R-15 | riga | 67.5 | 33.7 |
| 2026-07-16 02:43:35 | trip_start | V-005 | D-28 | R-10 | latgale | 76.8 | 15.5 |
| 2026-07-16 02:43:31 | gps_ping | V-035 | D-02 | R-08 | latgale | 75.5 | 42.5 |
| 2026-07-16 02:43:28 | gps_ping | V-047 | D-29 | R-06 | vidzeme | 81.6 | 13.2 |
| 2026-07-16 02:43:20 | gps_ping | V-009 | D-09 | R-01 | kurzeme | 62 | 32.7 |
| 2026-07-16 02:43:16 | gps_ping | V-025 | D-08 | R-10 | latgale | 25.7 | 29.7 |
| 2026-07-16 02:43:15 | engine_fault | V-031 | D-07 | R-04 | vidzeme | 23.9 | 28.6 |
| 2026-07-16 02:43:14 | gps_ping | V-032 | D-12 | R-03 | kurzeme | 29.7 | 11.9 |
| 2026-07-16 02:43:14 | refuel | V-043 | D-06 | R-11 | vidzeme | 0 | 27.3 |
| 2026-07-16 02:43:13 | gps_ping | V-017 | D-16 | R-12 | kurzeme | 30.4 | 23.8 |
| 2026-07-16 02:43:12 | gps_ping | V-042 | D-02 | R-10 | latgale | 88.5 | 32.3 |
| 2026-07-16 02:43:11 | gps_ping | V-004 | D-16 | R-11 | vidzeme | 85.6 | 24.2 |
| 2026-07-16 02:43:07 | trip_end | V-031 | D-12 | R-10 | latgale | 31.3 | 30.3 |
| 2026-07-16 02:43:06 | refuel | V-026 | D-20 | R-15 | riga | 0 | 13.8 |
| 2026-07-16 02:42:58 | trip_start | V-043 | D-15 | R-14 | latgale | 57.3 | 23.8 |
| 2026-07-16 02:42:57 | gps_ping | V-038 | D-16 | R-04 | vidzeme | 43 | 26.9 |
| 2026-07-16 02:42:57 | gps_ping | V-005 | D-14 | R-05 | riga | 71.1 | 15.1 |
| 2026-07-16 02:42:56 | gps_ping | V-001 | D-13 | R-15 | riga | 98.8 | 30.4 |
| 2026-07-16 02:42:55 | gps_ping | V-021 | D-16 | R-14 | latgale | 85.5 | 31.7 |
| 2026-07-16 02:42:54 | gps_ping | V-009 | D-06 | R-12 | kurzeme | 65.1 | 27.1 |
| 2026-07-16 02:42:54 | gps_ping | V-023 | D-06 | R-10 | latgale | 35.8 | 32.5 |
| 2026-07-16 02:42:51 | trip_end | V-046 | D-05 | R-05 | riga | 39 | 29.1 |
| 2026-07-16 02:42:49 | refuel | V-040 | D-28 | R-05 | riga | 0 | 30.9 |
| 2026-07-16 02:42:46 | gps_ping | V-027 | D-28 | R-14 | latgale | 57.2 | 30.1 |
| 2026-07-16 02:42:42 | refuel | V-048 | D-07 | R-03 | kurzeme | 0 | 27.1 |
| 2026-07-16 02:42:37 | gps_ping | V-036 | D-03 | R-10 | latgale | 54.3 | 28.5 |