События (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 00:39:59 | trip_end | V-012 | D-05 | R-02 | kurzeme | 66.9 | 32.8 |
| 2026-07-16 00:39:55 | gps_ping | V-024 | D-05 | R-10 | latgale | 66.4 | 10.9 |
| 2026-07-16 00:39:52 | harsh_braking | V-032 | D-14 | R-13 | latgale | 63.4 | 18.1 |
| 2026-07-16 00:39:50 | speeding | V-010 | D-10 | R-08 | latgale | 78.8 | 26.4 |
| 2026-07-16 00:39:48 | gps_ping | V-037 | D-10 | R-04 | vidzeme | 31.3 | 33.9 |
| 2026-07-16 00:39:46 | gps_ping | V-027 | D-06 | R-10 | latgale | 31.5 | 26.1 |
| 2026-07-16 00:39:44 | speeding | V-023 | D-04 | R-04 | vidzeme | 40.4 | 33.3 |
| 2026-07-16 00:39:44 | gps_ping | V-041 | D-27 | R-03 | kurzeme | 27.3 | 25.3 |
| 2026-07-16 00:39:43 | gps_ping | V-018 | D-18 | R-01 | kurzeme | 29 | 15.5 |
| 2026-07-16 00:39:34 | gps_ping | V-040 | D-15 | R-02 | kurzeme | 60.5 | 34.3 |
| 2026-07-16 00:39:29 | gps_ping | V-037 | D-15 | R-14 | latgale | 60.6 | 36.6 |
| 2026-07-16 00:39:28 | idle | V-014 | D-19 | R-14 | latgale | 0 | 36.3 |
| 2026-07-16 00:39:28 | gps_ping | V-020 | D-21 | R-15 | riga | 57.2 | 30.2 |
| 2026-07-16 00:39:24 | speeding | V-039 | D-05 | R-14 | latgale | 23.2 | 11.2 |
| 2026-07-16 00:39:23 | trip_end | V-013 | D-26 | R-11 | vidzeme | 69.5 | 14.1 |
| 2026-07-16 00:39:13 | gps_ping | V-021 | D-20 | R-10 | latgale | 66.7 | 35.2 |
| 2026-07-16 00:39:10 | speeding | V-026 | D-02 | R-05 | riga | 27 | 13.6 |
| 2026-07-16 00:39:10 | gps_ping | V-013 | D-29 | R-10 | latgale | 89.4 | 13.1 |
| 2026-07-16 00:39:08 | harsh_braking | V-021 | D-24 | R-04 | vidzeme | 44.1 | 37.3 |
| 2026-07-16 00:39:05 | gps_ping | V-026 | D-01 | R-12 | kurzeme | 72.9 | 12.9 |
| 2026-07-16 00:39:04 | gps_ping | V-022 | D-09 | R-15 | riga | 88.7 | 23.8 |
| 2026-07-16 00:39:01 | trip_start | V-005 | D-03 | R-08 | latgale | 24.4 | 10.7 |
| 2026-07-16 00:39:01 | gps_ping | V-021 | D-15 | R-05 | riga | 17.2 | 35.4 |
| 2026-07-16 00:39:01 | trip_start | V-017 | D-15 | R-02 | kurzeme | 54.3 | 19.3 |
| 2026-07-16 00:39:00 | gps_ping | V-030 | D-16 | R-14 | latgale | 26.2 | 12.8 |
| 2026-07-16 00:38:59 | trip_end | V-036 | D-20 | R-03 | kurzeme | 59.3 | 24.3 |
| 2026-07-16 00:38:48 | refuel | V-042 | D-24 | R-05 | riga | 0 | 27.9 |
| 2026-07-16 00:38:48 | idle | V-035 | D-13 | R-05 | riga | 0 | 35 |
| 2026-07-16 00:38:43 | gps_ping | V-034 | D-17 | R-01 | kurzeme | 86.2 | 30.8 |
| 2026-07-16 00:38:41 | harsh_braking | V-002 | D-04 | R-11 | vidzeme | 41.9 | 37.1 |
| 2026-07-16 00:38:36 | trip_end | V-040 | D-10 | R-10 | latgale | 54.9 | 31 |
| 2026-07-16 00:38:30 | harsh_braking | V-030 | D-04 | R-10 | latgale | 85.6 | 15.1 |
| 2026-07-16 00:38:30 | gps_ping | V-039 | D-23 | R-08 | latgale | 57.5 | 19.5 |
| 2026-07-16 00:38:28 | refuel | V-016 | D-06 | R-02 | kurzeme | 0 | 33.7 |
| 2026-07-16 00:38:27 | idle | V-007 | D-16 | R-01 | kurzeme | 0 | 12 |
| 2026-07-16 00:38:25 | refuel | V-027 | D-05 | R-06 | vidzeme | 0 | 30.9 |
| 2026-07-16 00:38:23 | gps_ping | V-027 | D-05 | R-08 | latgale | 88.1 | 32.4 |
| 2026-07-16 00:38:20 | refuel | V-004 | D-14 | R-03 | kurzeme | 0 | 25.6 |
| 2026-07-16 00:38:19 | gps_ping | V-041 | D-08 | R-11 | vidzeme | 44.4 | 31.7 |
| 2026-07-16 00:37:59 | engine_fault | V-012 | D-10 | R-11 | vidzeme | 31.6 | 38.7 |
| 2026-07-16 00:37:59 | engine_fault | V-004 | D-21 | R-01 | kurzeme | 62.9 | 29.7 |
| 2026-07-16 00:37:56 | refuel | V-026 | D-04 | R-07 | riga | 0 | 13.6 |
| 2026-07-16 00:37:53 | gps_ping | V-031 | D-30 | R-14 | latgale | 66.6 | 28 |
| 2026-07-16 00:37:50 | gps_ping | V-029 | D-01 | R-13 | latgale | 50.5 | 25.4 |
| 2026-07-16 00:37:48 | gps_ping | V-017 | D-14 | R-05 | riga | 57.5 | 31.3 |
| 2026-07-16 00:37:47 | gps_ping | V-010 | D-07 | R-13 | latgale | 34.6 | 27.3 |
| 2026-07-16 00:37:45 | gps_ping | V-037 | D-29 | R-14 | latgale | 45.6 | 28.9 |
| 2026-07-16 00:37:44 | gps_ping | V-036 | D-23 | R-01 | kurzeme | 45.8 | 26 |
| 2026-07-16 00:37:35 | gps_ping | V-021 | D-02 | R-15 | riga | 22.9 | 29.2 |
| 2026-07-16 00:37:31 | trip_end | V-028 | D-30 | R-15 | riga | 65.8 | 34.7 |