События (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:48:03 | refuel | V-041 | D-20 | R-05 | riga | 0 | 30.4 |
| 2026-07-16 01:48:03 | trip_end | V-011 | D-08 | R-04 | vidzeme | 48.9 | 13.1 |
| 2026-07-16 01:48:01 | refuel | V-034 | D-21 | R-12 | kurzeme | 0 | 28.6 |
| 2026-07-16 01:48:01 | trip_end | V-030 | D-08 | R-14 | latgale | 75.4 | 14.7 |
| 2026-07-16 01:48:00 | trip_start | V-025 | D-17 | R-06 | vidzeme | 65.1 | 25.3 |
| 2026-07-16 01:47:56 | gps_ping | V-037 | D-29 | R-02 | kurzeme | 38.7 | 29.8 |
| 2026-07-16 01:47:51 | idle | V-049 | D-19 | R-12 | kurzeme | 0 | 27.8 |
| 2026-07-16 01:47:45 | gps_ping | V-027 | D-22 | R-06 | vidzeme | 52.8 | 26.8 |
| 2026-07-16 01:47:43 | gps_ping | V-019 | D-18 | R-07 | riga | 48.8 | 24.6 |
| 2026-07-16 01:47:43 | harsh_braking | V-003 | D-24 | R-13 | latgale | 72.6 | 27.8 |
| 2026-07-16 01:47:42 | refuel | V-032 | D-22 | R-01 | kurzeme | 0 | 15.1 |
| 2026-07-16 01:47:40 | gps_ping | V-022 | D-23 | R-13 | latgale | 26.9 | 28.1 |
| 2026-07-16 01:47:39 | harsh_braking | V-007 | D-19 | R-14 | latgale | 69.5 | 16 |
| 2026-07-16 01:47:36 | gps_ping | V-050 | D-09 | R-12 | kurzeme | 34.9 | 28.6 |
| 2026-07-16 01:47:33 | engine_fault | V-015 | D-30 | R-03 | kurzeme | 40.2 | 25 |
| 2026-07-16 01:47:32 | gps_ping | V-005 | D-24 | R-06 | vidzeme | 38.2 | 18.4 |
| 2026-07-16 01:47:29 | gps_ping | V-023 | D-30 | R-11 | vidzeme | 74.4 | 38.4 |
| 2026-07-16 01:47:27 | refuel | V-031 | D-27 | R-01 | kurzeme | 0 | 25.1 |
| 2026-07-16 01:47:24 | gps_ping | V-050 | D-06 | R-03 | kurzeme | 46.1 | 28 |
| 2026-07-16 01:47:17 | gps_ping | V-028 | D-10 | R-09 | riga | 65.9 | 42.1 |
| 2026-07-16 01:47:17 | gps_ping | V-034 | D-25 | R-08 | latgale | 60.3 | 25.9 |
| 2026-07-16 01:47:15 | gps_ping | V-029 | D-02 | R-10 | latgale | 55.7 | 27.1 |
| 2026-07-16 01:47:12 | engine_fault | V-005 | D-27 | R-06 | vidzeme | 43.3 | 20.2 |
| 2026-07-16 01:47:07 | idle | V-027 | D-02 | R-13 | latgale | 0 | 30.8 |
| 2026-07-16 01:47:02 | trip_start | V-042 | D-13 | R-12 | kurzeme | 76.8 | 27.6 |
| 2026-07-16 01:47:00 | gps_ping | V-002 | D-11 | R-03 | kurzeme | 64.9 | 40.3 |
| 2026-07-16 01:46:54 | gps_ping | V-047 | D-04 | R-11 | vidzeme | 74.2 | 18.9 |
| 2026-07-16 01:46:53 | trip_end | V-019 | D-17 | R-11 | vidzeme | 56 | 23.5 |
| 2026-07-16 01:46:44 | gps_ping | V-042 | D-06 | R-08 | latgale | 60.1 | 30.1 |
| 2026-07-16 01:46:43 | trip_start | V-048 | D-02 | R-03 | kurzeme | 54.7 | 39.4 |
| 2026-07-16 01:46:39 | gps_ping | V-042 | D-27 | R-06 | vidzeme | 42.7 | 38.2 |
| 2026-07-16 01:46:33 | gps_ping | V-030 | D-29 | R-13 | latgale | 95.3 | 10.8 |
| 2026-07-16 01:46:28 | gps_ping | V-032 | D-15 | R-15 | riga | 74.1 | 17.8 |
| 2026-07-16 01:46:23 | gps_ping | V-023 | D-07 | R-07 | riga | 26.1 | 33.8 |
| 2026-07-16 01:46:21 | gps_ping | V-029 | D-20 | R-09 | riga | 88.7 | 23 |
| 2026-07-16 01:46:21 | trip_start | V-027 | D-17 | R-08 | latgale | 79.9 | 25.8 |
| 2026-07-16 01:46:21 | gps_ping | V-024 | D-07 | R-08 | latgale | 27.5 | 13.7 |
| 2026-07-16 01:46:17 | gps_ping | V-015 | D-07 | R-15 | riga | 54.6 | 30 |
| 2026-07-16 01:46:13 | gps_ping | V-036 | D-14 | R-01 | kurzeme | 44.1 | 26.5 |
| 2026-07-16 01:46:12 | gps_ping | V-009 | D-17 | R-02 | kurzeme | 89.6 | 37.7 |
| 2026-07-16 01:46:12 | trip_end | V-048 | D-08 | R-09 | riga | 40.7 | 27.7 |
| 2026-07-16 01:46:11 | gps_ping | V-030 | D-01 | R-15 | riga | 53 | 13.2 |
| 2026-07-16 01:46:07 | trip_start | V-012 | D-19 | R-10 | latgale | 48.4 | 31 |
| 2026-07-16 01:46:02 | engine_fault | V-048 | D-08 | R-12 | kurzeme | 29.9 | 30.4 |
| 2026-07-16 01:46:02 | gps_ping | V-037 | D-22 | R-14 | latgale | 91.2 | 30.9 |
| 2026-07-16 01:46:01 | gps_ping | V-039 | D-06 | R-13 | latgale | 37.7 | 15.9 |
| 2026-07-16 01:46:00 | gps_ping | V-023 | D-08 | R-05 | riga | 39.1 | 29.1 |
| 2026-07-16 01:45:55 | gps_ping | V-033 | D-08 | R-06 | vidzeme | 73.1 | 27.2 |
| 2026-07-16 01:45:46 | gps_ping | V-012 | D-18 | R-08 | latgale | 47.2 | 25 |
| 2026-07-16 01:45:43 | engine_fault | V-041 | D-08 | R-14 | latgale | 31.1 | 28.7 |