События (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:48:40 | trip_end | V-009 | D-30 | R-06 | vidzeme | 39.5 | 38.5 |
| 2026-07-16 02:48:40 | gps_ping | V-021 | D-22 | R-01 | kurzeme | 37.7 | 30.5 |
| 2026-07-16 02:48:39 | gps_ping | V-004 | D-04 | R-01 | kurzeme | 91.4 | 26.5 |
| 2026-07-16 02:48:35 | gps_ping | V-048 | D-15 | R-14 | latgale | 78.7 | 21.8 |
| 2026-07-16 02:48:33 | idle | V-044 | D-04 | R-15 | riga | 0 | 24.8 |
| 2026-07-16 02:48:32 | idle | V-040 | D-29 | R-06 | vidzeme | 0 | 32.5 |
| 2026-07-16 02:48:31 | gps_ping | V-040 | D-19 | R-05 | riga | 23.5 | 40.4 |
| 2026-07-16 02:48:26 | gps_ping | V-048 | D-23 | R-04 | vidzeme | 34.5 | 30.5 |
| 2026-07-16 02:48:25 | gps_ping | V-005 | D-18 | R-15 | riga | 59.4 | 11.8 |
| 2026-07-16 02:48:24 | gps_ping | V-027 | D-24 | R-05 | riga | 79.3 | 25.4 |
| 2026-07-16 02:48:22 | gps_ping | V-011 | D-07 | R-03 | kurzeme | 69.8 | 12.3 |
| 2026-07-16 02:48:20 | gps_ping | V-045 | D-28 | R-14 | latgale | 47.8 | 17.8 |
| 2026-07-16 02:48:17 | gps_ping | V-041 | D-23 | R-08 | latgale | 80.2 | 29.2 |
| 2026-07-16 02:48:17 | trip_end | V-029 | D-11 | R-02 | kurzeme | 90.1 | 37 |
| 2026-07-16 02:48:16 | gps_ping | V-010 | D-30 | R-12 | kurzeme | 31.4 | 27.3 |
| 2026-07-16 02:48:15 | gps_ping | V-023 | D-06 | R-10 | latgale | 29.5 | 33.7 |
| 2026-07-16 02:48:12 | gps_ping | V-043 | D-10 | R-10 | latgale | 70.4 | 27.4 |
| 2026-07-16 02:48:08 | trip_start | V-044 | D-18 | R-14 | latgale | 38.3 | 29 |
| 2026-07-16 02:48:02 | refuel | V-041 | D-09 | R-14 | latgale | 0 | 36.3 |
| 2026-07-16 02:47:59 | gps_ping | V-007 | D-12 | R-10 | latgale | 54.8 | 16.9 |
| 2026-07-16 02:47:58 | gps_ping | V-049 | D-19 | R-09 | riga | 77.7 | 33.1 |
| 2026-07-16 02:47:58 | speeding | V-038 | D-20 | R-05 | riga | 59.1 | 39.3 |
| 2026-07-16 02:47:46 | gps_ping | V-007 | D-19 | R-02 | kurzeme | 62.1 | 16.2 |
| 2026-07-16 02:47:44 | gps_ping | V-048 | D-22 | R-08 | latgale | 61.6 | 28.3 |
| 2026-07-16 02:47:43 | gps_ping | V-026 | D-20 | R-14 | latgale | 95 | 14.8 |
| 2026-07-16 02:47:42 | trip_end | V-049 | D-23 | R-11 | vidzeme | 61.1 | 28.7 |
| 2026-07-16 02:47:40 | gps_ping | V-050 | D-29 | R-12 | kurzeme | 66.1 | 31.9 |
| 2026-07-16 02:47:39 | gps_ping | V-017 | D-26 | R-04 | vidzeme | 20.6 | 32.4 |
| 2026-07-16 02:47:32 | gps_ping | V-026 | D-06 | R-02 | kurzeme | 53 | 14.2 |
| 2026-07-16 02:47:30 | harsh_braking | V-048 | D-15 | R-05 | riga | 51.3 | 29.8 |
| 2026-07-16 02:47:29 | trip_end | V-001 | D-07 | R-02 | kurzeme | 76.1 | 31.6 |
| 2026-07-16 02:47:20 | speeding | V-007 | D-04 | R-14 | latgale | 67.5 | 14.6 |
| 2026-07-16 02:47:20 | trip_end | V-050 | D-12 | R-04 | vidzeme | 54.9 | 29.7 |
| 2026-07-16 02:47:19 | gps_ping | V-013 | D-13 | R-12 | kurzeme | 29.3 | 15.1 |
| 2026-07-16 02:47:16 | gps_ping | V-016 | D-13 | R-12 | kurzeme | 91.8 | 33.4 |
| 2026-07-16 02:47:16 | gps_ping | V-014 | D-26 | R-01 | kurzeme | 54.7 | 36.7 |
| 2026-07-16 02:47:13 | gps_ping | V-018 | D-08 | R-01 | kurzeme | 40.4 | 9.4 |
| 2026-07-16 02:47:11 | idle | V-003 | D-26 | R-11 | vidzeme | 0 | 27.2 |
| 2026-07-16 02:47:08 | trip_end | V-034 | D-13 | R-09 | riga | 89.5 | 28.5 |
| 2026-07-16 02:47:07 | trip_end | V-004 | D-16 | R-03 | kurzeme | 78.4 | 34.6 |
| 2026-07-16 02:47:06 | refuel | V-001 | D-12 | R-08 | latgale | 0 | 37.2 |
| 2026-07-16 02:47:04 | gps_ping | V-012 | D-14 | R-11 | vidzeme | 61.5 | 34.4 |
| 2026-07-16 02:47:02 | gps_ping | V-008 | D-11 | R-12 | kurzeme | 66.1 | 33.2 |
| 2026-07-16 02:47:01 | gps_ping | V-039 | D-15 | R-13 | latgale | 87 | 13.4 |
| 2026-07-16 02:46:51 | gps_ping | V-019 | D-16 | R-09 | riga | 49.4 | 28.1 |
| 2026-07-16 02:46:50 | gps_ping | V-042 | D-27 | R-12 | kurzeme | 75.6 | 28.8 |
| 2026-07-16 02:46:49 | gps_ping | V-041 | D-26 | R-10 | latgale | 68.2 | 26.9 |
| 2026-07-16 02:46:49 | idle | V-039 | D-13 | R-08 | latgale | 0 | 18.9 |
| 2026-07-16 02:46:48 | gps_ping | V-037 | D-27 | R-07 | riga | 26.6 | 38.8 |
| 2026-07-16 02:46:45 | harsh_braking | V-014 | D-13 | R-10 | latgale | 79.6 | 35.2 |