События (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:50:57 | gps_ping | V-013 | D-13 | R-12 | kurzeme | 84.3 | 13.4 |
| 2026-07-16 02:50:52 | trip_end | V-027 | D-08 | R-05 | riga | 40.8 | 34.1 |
| 2026-07-16 02:50:46 | idle | V-033 | D-12 | R-01 | kurzeme | 0 | 29.6 |
| 2026-07-16 02:50:38 | gps_ping | V-033 | D-25 | R-07 | riga | 40.4 | 30.1 |
| 2026-07-16 02:50:37 | gps_ping | V-023 | D-28 | R-06 | vidzeme | 40.7 | 32.6 |
| 2026-07-16 02:50:35 | gps_ping | V-041 | D-08 | R-09 | riga | 76.3 | 29.9 |
| 2026-07-16 02:50:32 | harsh_braking | V-043 | D-20 | R-02 | kurzeme | 43.8 | 29.1 |
| 2026-07-16 02:50:31 | gps_ping | V-019 | D-12 | R-04 | vidzeme | 17.1 | 31 |
| 2026-07-16 02:50:31 | engine_fault | V-046 | D-16 | R-07 | riga | 39.9 | 29.9 |
| 2026-07-16 02:50:28 | gps_ping | V-001 | D-10 | R-12 | kurzeme | 49.9 | 29.6 |
| 2026-07-16 02:50:26 | gps_ping | V-050 | D-05 | R-06 | vidzeme | 41.2 | 28.1 |
| 2026-07-16 02:50:26 | trip_start | V-042 | D-10 | R-06 | vidzeme | 45.7 | 34.3 |
| 2026-07-16 02:50:19 | trip_end | V-015 | D-12 | R-11 | vidzeme | 52.7 | 30 |
| 2026-07-16 02:50:14 | gps_ping | V-007 | D-15 | R-12 | kurzeme | 50.5 | 14.7 |
| 2026-07-16 02:50:11 | gps_ping | V-027 | D-17 | R-15 | riga | 79.5 | 25.3 |
| 2026-07-16 02:50:06 | gps_ping | V-005 | D-05 | R-10 | latgale | 22.6 | 13.5 |
| 2026-07-16 02:50:04 | harsh_braking | V-020 | D-17 | R-14 | latgale | 21.3 | 28.6 |
| 2026-07-16 02:50:04 | trip_end | V-047 | D-21 | R-01 | kurzeme | 46.2 | 15 |
| 2026-07-16 02:50:02 | gps_ping | V-017 | D-25 | R-04 | vidzeme | 54.8 | 24.4 |
| 2026-07-16 02:50:02 | gps_ping | V-025 | D-23 | R-01 | kurzeme | 34.6 | 28.1 |
| 2026-07-16 02:49:56 | harsh_braking | V-007 | D-13 | R-02 | kurzeme | 85.6 | 14.5 |
| 2026-07-16 02:49:55 | idle | V-011 | D-21 | R-15 | riga | 0 | 13.1 |
| 2026-07-16 02:49:52 | refuel | V-003 | D-28 | R-11 | vidzeme | 0 | 27.4 |
| 2026-07-16 02:49:50 | gps_ping | V-041 | D-30 | R-06 | vidzeme | 52.3 | 24.6 |
| 2026-07-16 02:49:49 | speeding | V-006 | D-18 | R-03 | kurzeme | 85.9 | 23.9 |
| 2026-07-16 02:49:49 | gps_ping | V-019 | D-22 | R-04 | vidzeme | 42.6 | 29.1 |
| 2026-07-16 02:49:48 | speeding | V-029 | D-10 | R-01 | kurzeme | 37.6 | 25.2 |
| 2026-07-16 02:49:45 | gps_ping | V-006 | D-05 | R-03 | kurzeme | 31.6 | 27 |
| 2026-07-16 02:49:43 | gps_ping | V-014 | D-29 | R-04 | vidzeme | 42.3 | 30.3 |
| 2026-07-16 02:49:41 | gps_ping | V-028 | D-18 | R-15 | riga | 60.5 | 31.6 |
| 2026-07-16 02:49:41 | gps_ping | V-030 | D-08 | R-05 | riga | 30.1 | 17.6 |
| 2026-07-16 02:49:39 | gps_ping | V-011 | D-22 | R-12 | kurzeme | 37.5 | 18.3 |
| 2026-07-16 02:49:39 | gps_ping | V-027 | D-16 | R-14 | latgale | 68.3 | 29 |
| 2026-07-16 02:49:21 | trip_start | V-018 | D-24 | R-12 | kurzeme | 24.7 | 17.8 |
| 2026-07-16 02:49:21 | gps_ping | V-033 | D-21 | R-07 | riga | 84.7 | 26.8 |
| 2026-07-16 02:49:19 | trip_start | V-039 | D-08 | R-14 | latgale | 40.9 | 15.7 |
| 2026-07-16 02:49:13 | gps_ping | V-039 | D-02 | R-01 | kurzeme | 81.4 | 16.5 |
| 2026-07-16 02:49:11 | refuel | V-033 | D-24 | R-11 | vidzeme | 0 | 29.5 |
| 2026-07-16 02:49:11 | trip_start | V-006 | D-01 | R-14 | latgale | 89.1 | 27.6 |
| 2026-07-16 02:49:05 | gps_ping | V-001 | D-17 | R-06 | vidzeme | 69.8 | 22.2 |
| 2026-07-16 02:49:05 | gps_ping | V-038 | D-08 | R-14 | latgale | 73.2 | 29.4 |
| 2026-07-16 02:49:04 | gps_ping | V-034 | D-06 | R-12 | kurzeme | 87.3 | 30.7 |
| 2026-07-16 02:49:02 | refuel | V-031 | D-13 | R-10 | latgale | 0 | 37.2 |
| 2026-07-16 02:49:01 | gps_ping | V-012 | D-25 | R-14 | latgale | 75.8 | 32.2 |
| 2026-07-16 02:49:01 | gps_ping | V-031 | D-01 | R-03 | kurzeme | 72.8 | 29.8 |
| 2026-07-16 02:48:53 | harsh_braking | V-024 | D-08 | R-03 | kurzeme | 24.2 | 13.8 |
| 2026-07-16 02:48:52 | gps_ping | V-017 | D-21 | R-10 | latgale | 54.8 | 32.4 |
| 2026-07-16 02:48:48 | gps_ping | V-021 | D-01 | R-06 | vidzeme | 82.4 | 29.9 |
| 2026-07-16 02:48:45 | gps_ping | V-031 | D-29 | R-12 | kurzeme | 62.7 | 27.5 |
| 2026-07-16 02:48:45 | speeding | V-047 | D-17 | R-03 | kurzeme | 82.8 | 13.7 |