События (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 03:06:19 | trip_start | V-029 | D-15 | R-12 | kurzeme | 41.7 | 28.4 |
| 2026-07-16 03:06:10 | gps_ping | V-043 | D-08 | R-06 | vidzeme | 35.4 | 33.8 |
| 2026-07-16 03:06:00 | idle | V-022 | D-12 | R-09 | riga | 0 | 38.7 |
| 2026-07-16 03:05:56 | trip_end | V-006 | D-20 | R-11 | vidzeme | 62.4 | 25.2 |
| 2026-07-16 03:05:55 | gps_ping | V-047 | D-19 | R-10 | latgale | 74.2 | 14 |
| 2026-07-16 03:05:54 | gps_ping | V-040 | D-04 | R-15 | riga | 29.6 | 37 |
| 2026-07-16 03:05:50 | trip_start | V-024 | D-19 | R-06 | vidzeme | 65.8 | 16.4 |
| 2026-07-16 03:05:50 | refuel | V-011 | D-22 | R-09 | riga | 0 | 15.2 |
| 2026-07-16 03:05:49 | gps_ping | V-023 | D-20 | R-06 | vidzeme | 66.3 | 35.3 |
| 2026-07-16 03:05:49 | gps_ping | V-049 | D-02 | R-05 | riga | 35.1 | 30.1 |
| 2026-07-16 03:05:48 | gps_ping | V-029 | D-11 | R-13 | latgale | 60.1 | 31.7 |
| 2026-07-16 03:05:48 | engine_fault | V-015 | D-18 | R-05 | riga | 42.6 | 25 |
| 2026-07-16 03:05:48 | gps_ping | V-023 | D-21 | R-15 | riga | 33.3 | 28.3 |
| 2026-07-16 03:05:47 | gps_ping | V-026 | D-21 | R-09 | riga | 34.9 | 14.7 |
| 2026-07-16 03:05:47 | trip_start | V-037 | D-25 | R-15 | riga | 46.6 | 36.5 |
| 2026-07-16 03:05:42 | gps_ping | V-020 | D-06 | R-02 | kurzeme | 76.4 | 27.6 |
| 2026-07-16 03:05:41 | gps_ping | V-024 | D-26 | R-02 | kurzeme | 69.9 | 15.9 |
| 2026-07-16 03:05:40 | trip_start | V-003 | D-02 | R-06 | vidzeme | 40.9 | 25.5 |
| 2026-07-16 03:05:38 | gps_ping | V-021 | D-07 | R-03 | kurzeme | 75 | 32.8 |
| 2026-07-16 03:05:35 | trip_start | V-005 | D-02 | R-08 | latgale | 72.9 | 14.7 |
| 2026-07-16 03:05:33 | gps_ping | V-047 | D-11 | R-12 | kurzeme | 68.1 | 17.3 |
| 2026-07-16 03:05:23 | trip_start | V-041 | D-06 | R-14 | latgale | 68.7 | 28.3 |
| 2026-07-16 03:05:23 | gps_ping | V-005 | D-10 | R-11 | vidzeme | 50.7 | 13.3 |
| 2026-07-16 03:05:23 | engine_fault | V-020 | D-21 | R-10 | latgale | 96.9 | 24.9 |
| 2026-07-16 03:05:20 | gps_ping | V-031 | D-20 | R-01 | kurzeme | 43.5 | 30.5 |
| 2026-07-16 03:05:16 | refuel | V-014 | D-20 | R-01 | kurzeme | 0 | 28.8 |
| 2026-07-16 03:05:14 | gps_ping | V-038 | D-26 | R-08 | latgale | 21.4 | 23.4 |
| 2026-07-16 03:05:10 | gps_ping | V-023 | D-05 | R-13 | latgale | 66 | 39.3 |
| 2026-07-16 03:05:10 | trip_end | V-046 | D-25 | R-12 | kurzeme | 90.5 | 25.7 |
| 2026-07-16 03:04:55 | gps_ping | V-003 | D-01 | R-07 | riga | 92.9 | 29.8 |
| 2026-07-16 03:04:54 | speeding | V-009 | D-24 | R-11 | vidzeme | 66.3 | 42 |
| 2026-07-16 03:04:54 | trip_start | V-009 | D-11 | R-08 | latgale | 41.8 | 32.7 |
| 2026-07-16 03:04:54 | gps_ping | V-033 | D-22 | R-02 | kurzeme | 30 | 29.7 |
| 2026-07-16 03:04:53 | gps_ping | V-011 | D-11 | R-13 | latgale | 44.5 | 14.1 |
| 2026-07-16 03:04:51 | gps_ping | V-050 | D-12 | R-11 | vidzeme | 60.8 | 28.4 |
| 2026-07-16 03:04:49 | idle | V-021 | D-09 | R-09 | riga | 0 | 28.9 |
| 2026-07-16 03:04:45 | gps_ping | V-030 | D-27 | R-05 | riga | 50.1 | 12.2 |
| 2026-07-16 03:04:45 | engine_fault | V-022 | D-08 | R-04 | vidzeme | 35.6 | 33 |
| 2026-07-16 03:04:44 | trip_end | V-037 | D-19 | R-12 | kurzeme | 81 | 33.4 |
| 2026-07-16 03:04:34 | gps_ping | V-045 | D-16 | R-15 | riga | 28.7 | 11.6 |
| 2026-07-16 03:04:33 | gps_ping | V-034 | D-13 | R-14 | latgale | 62.5 | 21.2 |
| 2026-07-16 03:04:31 | refuel | V-023 | D-07 | R-07 | riga | 0 | 31.8 |
| 2026-07-16 03:04:31 | trip_end | V-044 | D-28 | R-08 | latgale | 94.6 | 31.8 |
| 2026-07-16 03:04:29 | gps_ping | V-017 | D-01 | R-02 | kurzeme | 59.6 | 28.9 |
| 2026-07-16 03:04:27 | gps_ping | V-045 | D-13 | R-03 | kurzeme | 35.6 | 14.3 |
| 2026-07-16 03:04:21 | trip_end | V-033 | D-25 | R-14 | latgale | 80.3 | 27.5 |
| 2026-07-16 03:04:21 | engine_fault | V-040 | D-14 | R-09 | riga | 58.1 | 32.7 |
| 2026-07-16 03:04:10 | idle | V-038 | D-02 | R-10 | latgale | 0 | 27 |
| 2026-07-16 03:04:09 | gps_ping | V-019 | D-11 | R-03 | kurzeme | 35.1 | 32.7 |
| 2026-07-16 03:04:08 | gps_ping | V-028 | D-02 | R-14 | latgale | 53.1 | 37.1 |