События (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:27:30 | gps_ping | V-049 | D-26 | R-05 | riga | 71.1 | 33.1 |
| 2026-07-16 01:27:27 | gps_ping | V-013 | D-27 | R-13 | latgale | 39.6 | 12.9 |
| 2026-07-16 01:27:26 | gps_ping | V-045 | D-12 | R-04 | vidzeme | 45.8 | 18.8 |
| 2026-07-16 01:27:25 | gps_ping | V-004 | D-30 | R-05 | riga | 98.6 | 29.1 |
| 2026-07-16 01:27:25 | gps_ping | V-004 | D-29 | R-02 | kurzeme | 74.2 | 28.1 |
| 2026-07-16 01:27:25 | gps_ping | V-019 | D-26 | R-14 | latgale | 59.4 | 26.8 |
| 2026-07-16 01:27:22 | refuel | V-043 | D-21 | R-12 | kurzeme | 0 | 27.1 |
| 2026-07-16 01:27:21 | gps_ping | V-046 | D-30 | R-10 | latgale | 48.5 | 28.6 |
| 2026-07-16 01:27:19 | refuel | V-022 | D-12 | R-02 | kurzeme | 0 | 21.1 |
| 2026-07-16 01:27:13 | gps_ping | V-048 | D-05 | R-13 | latgale | 88.3 | 30.5 |
| 2026-07-16 01:27:04 | gps_ping | V-039 | D-29 | R-06 | vidzeme | 84.6 | 12.6 |
| 2026-07-16 01:26:57 | gps_ping | V-034 | D-27 | R-12 | kurzeme | 58.7 | 30.5 |
| 2026-07-16 01:26:56 | trip_start | V-016 | D-08 | R-05 | riga | 83.5 | 33.4 |
| 2026-07-16 01:26:48 | idle | V-046 | D-03 | R-07 | riga | 0 | 31.2 |
| 2026-07-16 01:26:47 | gps_ping | V-025 | D-13 | R-02 | kurzeme | 56.2 | 26.4 |
| 2026-07-16 01:26:41 | gps_ping | V-049 | D-12 | R-13 | latgale | 30.1 | 28.1 |
| 2026-07-16 01:26:33 | trip_start | V-046 | D-12 | R-15 | riga | 66.6 | 26.8 |
| 2026-07-16 01:26:30 | refuel | V-020 | D-13 | R-15 | riga | 0 | 26.3 |
| 2026-07-16 01:26:29 | gps_ping | V-042 | D-18 | R-15 | riga | 83.6 | 32.9 |
| 2026-07-16 01:26:27 | trip_end | V-047 | D-28 | R-04 | vidzeme | 19.8 | 13 |
| 2026-07-16 01:26:20 | gps_ping | V-043 | D-17 | R-08 | latgale | 27.1 | 29.7 |
| 2026-07-16 01:26:18 | gps_ping | V-021 | D-05 | R-01 | kurzeme | 49.5 | 35.1 |
| 2026-07-16 01:26:18 | harsh_braking | V-010 | D-15 | R-04 | vidzeme | 36.8 | 29.8 |
| 2026-07-16 01:26:15 | gps_ping | V-044 | D-19 | R-13 | latgale | 73.8 | 26.3 |
| 2026-07-16 01:26:11 | trip_start | V-032 | D-03 | R-02 | kurzeme | 30.7 | 10.4 |
| 2026-07-16 01:26:01 | gps_ping | V-038 | D-04 | R-15 | riga | 91.2 | 27.1 |
| 2026-07-16 01:25:57 | speeding | V-018 | D-30 | R-12 | kurzeme | 59.1 | 18.1 |
| 2026-07-16 01:25:56 | trip_start | V-004 | D-15 | R-13 | latgale | 35.3 | 34.9 |
| 2026-07-16 01:25:53 | gps_ping | V-027 | D-03 | R-12 | kurzeme | 55.1 | 25.6 |
| 2026-07-16 01:25:52 | gps_ping | V-002 | D-03 | R-14 | latgale | 78.5 | 32.1 |
| 2026-07-16 01:25:51 | gps_ping | V-013 | D-13 | R-01 | kurzeme | 39.3 | 17.3 |
| 2026-07-16 01:25:50 | trip_end | V-041 | D-25 | R-08 | latgale | 31.2 | 33.3 |
| 2026-07-16 01:25:46 | gps_ping | V-014 | D-21 | R-04 | vidzeme | 39.8 | 33.9 |
| 2026-07-16 01:25:44 | idle | V-036 | D-26 | R-12 | kurzeme | 0 | 22.6 |
| 2026-07-16 01:25:41 | trip_end | V-027 | D-07 | R-13 | latgale | 53.9 | 27.1 |
| 2026-07-16 01:25:39 | gps_ping | V-028 | D-24 | R-01 | kurzeme | 73.5 | 27.7 |
| 2026-07-16 01:25:38 | gps_ping | V-005 | D-03 | R-15 | riga | 51.5 | 14.3 |
| 2026-07-16 01:25:38 | trip_start | V-033 | D-24 | R-01 | kurzeme | 75.8 | 31.1 |
| 2026-07-16 01:25:37 | gps_ping | V-041 | D-08 | R-06 | vidzeme | 66.7 | 21.9 |
| 2026-07-16 01:25:37 | engine_fault | V-034 | D-09 | R-04 | vidzeme | 47.8 | 27.8 |
| 2026-07-16 01:25:36 | gps_ping | V-022 | D-19 | R-10 | latgale | 66.4 | 29.5 |
| 2026-07-16 01:25:35 | gps_ping | V-006 | D-13 | R-08 | latgale | 66.4 | 38.9 |
| 2026-07-16 01:25:35 | trip_end | V-011 | D-30 | R-01 | kurzeme | 28.9 | 14.7 |
| 2026-07-16 01:25:33 | gps_ping | V-043 | D-14 | R-01 | kurzeme | 58.3 | 28.4 |
| 2026-07-16 01:25:32 | trip_end | V-049 | D-13 | R-03 | kurzeme | 35.5 | 31.9 |
| 2026-07-16 01:25:29 | gps_ping | V-033 | D-29 | R-04 | vidzeme | 16.1 | 29.9 |
| 2026-07-16 01:25:24 | gps_ping | V-027 | D-21 | R-03 | kurzeme | 29 | 28.4 |
| 2026-07-16 01:25:22 | gps_ping | V-006 | D-02 | R-04 | vidzeme | 31.2 | 26.7 |
| 2026-07-16 01:25:18 | gps_ping | V-008 | D-12 | R-12 | kurzeme | 66.6 | 31.1 |
| 2026-07-16 01:25:17 | gps_ping | V-034 | D-14 | R-06 | vidzeme | 80.4 | 31.6 |