События (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:56:20 | gps_ping | V-023 | D-01 | R-05 | riga | 55.4 | 32.3 |
| 2026-07-16 01:56:19 | refuel | V-026 | D-16 | R-12 | kurzeme | 0 | 14.4 |
| 2026-07-16 01:56:19 | gps_ping | V-038 | D-20 | R-15 | riga | 25.4 | 29.9 |
| 2026-07-16 01:56:18 | trip_end | V-038 | D-17 | R-11 | vidzeme | 70.9 | 29.8 |
| 2026-07-16 01:56:18 | idle | V-006 | D-05 | R-04 | vidzeme | 0 | 35.6 |
| 2026-07-16 01:56:16 | engine_fault | V-027 | D-04 | R-13 | latgale | 46.9 | 30.9 |
| 2026-07-16 01:56:13 | gps_ping | V-034 | D-03 | R-12 | kurzeme | 30.6 | 26.2 |
| 2026-07-16 01:56:09 | gps_ping | V-021 | D-06 | R-06 | vidzeme | 82.9 | 38 |
| 2026-07-16 01:56:07 | speeding | V-034 | D-18 | R-15 | riga | 57.5 | 25.1 |
| 2026-07-16 01:56:06 | trip_start | V-039 | D-08 | R-07 | riga | 85.8 | 14 |
| 2026-07-16 01:56:06 | gps_ping | V-036 | D-06 | R-03 | kurzeme | 72.8 | 27.2 |
| 2026-07-16 01:56:05 | trip_start | V-021 | D-20 | R-05 | riga | 43.2 | 30.5 |
| 2026-07-16 01:56:05 | gps_ping | V-035 | D-06 | R-14 | latgale | 86.9 | 35.3 |
| 2026-07-16 01:56:04 | trip_start | V-014 | D-19 | R-11 | vidzeme | 51.8 | 31.8 |
| 2026-07-16 01:56:01 | gps_ping | V-032 | D-07 | R-07 | riga | 43 | 16.6 |
| 2026-07-16 01:56:00 | gps_ping | V-043 | D-07 | R-14 | latgale | 77.1 | 29.4 |
| 2026-07-16 01:55:56 | gps_ping | V-016 | D-09 | R-01 | kurzeme | 74 | 31.3 |
| 2026-07-16 01:55:50 | gps_ping | V-015 | D-07 | R-03 | kurzeme | 92.1 | 22.4 |
| 2026-07-16 01:55:45 | gps_ping | V-046 | D-13 | R-08 | latgale | 38.8 | 36.4 |
| 2026-07-16 01:55:45 | speeding | V-046 | D-26 | R-10 | latgale | 26.5 | 26.9 |
| 2026-07-16 01:55:44 | idle | V-043 | D-04 | R-08 | latgale | 0 | 28.7 |
| 2026-07-16 01:55:43 | engine_fault | V-047 | D-17 | R-06 | vidzeme | 78.1 | 12.3 |
| 2026-07-16 01:55:40 | gps_ping | V-039 | D-02 | R-09 | riga | 38.7 | 17.9 |
| 2026-07-16 01:55:39 | gps_ping | V-006 | D-24 | R-01 | kurzeme | 47.4 | 28.4 |
| 2026-07-16 01:55:39 | trip_end | V-033 | D-27 | R-12 | kurzeme | 94.9 | 22.8 |
| 2026-07-16 01:55:39 | trip_start | V-043 | D-09 | R-10 | latgale | 51.7 | 29.8 |
| 2026-07-16 01:55:38 | refuel | V-010 | D-15 | R-01 | kurzeme | 0 | 31.1 |
| 2026-07-16 01:55:37 | gps_ping | V-034 | D-20 | R-03 | kurzeme | 21.9 | 28.9 |
| 2026-07-16 01:55:37 | refuel | V-019 | D-04 | R-09 | riga | 0 | 25.6 |
| 2026-07-16 01:55:37 | gps_ping | V-016 | D-29 | R-12 | kurzeme | 67.2 | 33.8 |
| 2026-07-16 01:55:24 | gps_ping | V-032 | D-26 | R-08 | latgale | 51.7 | 13.1 |
| 2026-07-16 01:55:23 | gps_ping | V-028 | D-27 | R-12 | kurzeme | 76.8 | 37.1 |
| 2026-07-16 01:55:23 | trip_end | V-001 | D-29 | R-03 | kurzeme | 51.9 | 26.9 |
| 2026-07-16 01:55:18 | gps_ping | V-009 | D-21 | R-09 | riga | 43.3 | 34 |
| 2026-07-16 01:55:15 | engine_fault | V-013 | D-09 | R-10 | latgale | 89.9 | 14.4 |
| 2026-07-16 01:55:14 | gps_ping | V-041 | D-10 | R-14 | latgale | 31 | 25.2 |
| 2026-07-16 01:55:12 | gps_ping | V-003 | D-29 | R-10 | latgale | 63.5 | 27.3 |
| 2026-07-16 01:55:11 | trip_end | V-022 | D-06 | R-13 | latgale | 30.9 | 32.6 |
| 2026-07-16 01:55:09 | refuel | V-003 | D-10 | R-13 | latgale | 0 | 28.9 |
| 2026-07-16 01:55:05 | gps_ping | V-038 | D-25 | R-11 | vidzeme | 71.7 | 29.1 |
| 2026-07-16 01:55:02 | gps_ping | V-005 | D-06 | R-12 | kurzeme | 54.6 | 18.2 |
| 2026-07-16 01:55:00 | idle | V-003 | D-09 | R-02 | kurzeme | 0 | 27.3 |
| 2026-07-16 01:54:58 | trip_start | V-006 | D-07 | R-01 | kurzeme | 65 | 28.3 |
| 2026-07-16 01:54:54 | speeding | V-039 | D-24 | R-10 | latgale | 52 | 14.6 |
| 2026-07-16 01:54:48 | gps_ping | V-020 | D-26 | R-14 | latgale | 84.2 | 34.1 |
| 2026-07-16 01:54:48 | speeding | V-036 | D-04 | R-07 | riga | 46.4 | 31.8 |
| 2026-07-16 01:54:41 | gps_ping | V-013 | D-18 | R-05 | riga | 84.7 | 13.6 |
| 2026-07-16 01:54:40 | trip_end | V-003 | D-05 | R-08 | latgale | 86.1 | 25.7 |
| 2026-07-16 01:54:39 | gps_ping | V-032 | D-03 | R-12 | kurzeme | 25.7 | 16.9 |
| 2026-07-16 01:54:39 | idle | V-035 | D-04 | R-05 | riga | 0 | 34 |