События (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:29:50 | gps_ping | V-022 | D-27 | R-06 | vidzeme | 55.4 | 28.3 |
| 2026-07-16 02:29:48 | engine_fault | V-001 | D-14 | R-01 | kurzeme | 43.9 | 27.9 |
| 2026-07-16 02:29:47 | gps_ping | V-002 | D-25 | R-11 | vidzeme | 58.1 | 37.2 |
| 2026-07-16 02:29:46 | gps_ping | V-035 | D-08 | R-01 | kurzeme | 36.8 | 27.2 |
| 2026-07-16 02:29:37 | gps_ping | V-035 | D-14 | R-10 | latgale | 36.2 | 35.5 |
| 2026-07-16 02:29:32 | trip_end | V-015 | D-15 | R-04 | vidzeme | 50.6 | 25.1 |
| 2026-07-16 02:29:32 | trip_end | V-009 | D-11 | R-10 | latgale | 79.2 | 31.5 |
| 2026-07-16 02:29:31 | trip_end | V-043 | D-21 | R-05 | riga | 80.4 | 28.5 |
| 2026-07-16 02:29:28 | trip_start | V-024 | D-28 | R-12 | kurzeme | 29.9 | 13.9 |
| 2026-07-16 02:29:27 | gps_ping | V-010 | D-30 | R-11 | vidzeme | 68.6 | 30.5 |
| 2026-07-16 02:29:23 | refuel | V-016 | D-07 | R-05 | riga | 0 | 33.1 |
| 2026-07-16 02:29:19 | gps_ping | V-020 | D-01 | R-05 | riga | 32.7 | 28.4 |
| 2026-07-16 02:29:17 | engine_fault | V-016 | D-20 | R-02 | kurzeme | 17.9 | 31.5 |
| 2026-07-16 02:29:13 | gps_ping | V-031 | D-11 | R-07 | riga | 51.3 | 28.7 |
| 2026-07-16 02:29:13 | trip_start | V-010 | D-13 | R-14 | latgale | 48.4 | 35.4 |
| 2026-07-16 02:29:08 | gps_ping | V-048 | D-25 | R-14 | latgale | 31.6 | 23.6 |
| 2026-07-16 02:29:06 | trip_start | V-050 | D-17 | R-12 | kurzeme | 48.2 | 29.4 |
| 2026-07-16 02:29:03 | trip_start | V-015 | D-23 | R-13 | latgale | 92.8 | 28.4 |
| 2026-07-16 02:29:00 | engine_fault | V-010 | D-11 | R-05 | riga | 30.7 | 28.8 |
| 2026-07-16 02:29:00 | gps_ping | V-023 | D-06 | R-02 | kurzeme | 32.9 | 31.1 |
| 2026-07-16 02:28:58 | idle | V-011 | D-01 | R-04 | vidzeme | 0 | 15.4 |
| 2026-07-16 02:28:58 | gps_ping | V-036 | D-11 | R-15 | riga | 44.2 | 24.8 |
| 2026-07-16 02:28:53 | gps_ping | V-008 | D-18 | R-07 | riga | 46.2 | 32.5 |
| 2026-07-16 02:28:51 | gps_ping | V-039 | D-26 | R-01 | kurzeme | 75.9 | 15.1 |
| 2026-07-16 02:28:48 | gps_ping | V-022 | D-26 | R-05 | riga | 86.9 | 25.5 |
| 2026-07-16 02:28:45 | engine_fault | V-022 | D-30 | R-13 | latgale | 51.4 | 27.7 |
| 2026-07-16 02:28:44 | engine_fault | V-004 | D-06 | R-13 | latgale | 46.8 | 27.6 |
| 2026-07-16 02:28:42 | gps_ping | V-012 | D-06 | R-09 | riga | 38.8 | 28.7 |
| 2026-07-16 02:28:42 | trip_end | V-035 | D-11 | R-14 | latgale | 51.4 | 33.5 |
| 2026-07-16 02:28:40 | trip_start | V-045 | D-18 | R-07 | riga | 30.3 | 15.3 |
| 2026-07-16 02:28:34 | idle | V-039 | D-30 | R-09 | riga | 0 | 14 |
| 2026-07-16 02:28:34 | trip_start | V-018 | D-30 | R-13 | latgale | 61 | 15.7 |
| 2026-07-16 02:28:32 | gps_ping | V-034 | D-16 | R-08 | latgale | 60.6 | 26.7 |
| 2026-07-16 02:28:31 | refuel | V-026 | D-01 | R-02 | kurzeme | 0 | 13.3 |
| 2026-07-16 02:28:28 | idle | V-013 | D-03 | R-05 | riga | 0 | 15.3 |
| 2026-07-16 02:28:27 | trip_start | V-048 | D-29 | R-01 | kurzeme | 95.6 | 25.9 |
| 2026-07-16 02:28:22 | gps_ping | V-037 | D-07 | R-12 | kurzeme | 35 | 35.1 |
| 2026-07-16 02:28:19 | gps_ping | V-034 | D-23 | R-08 | latgale | 82.9 | 24.6 |
| 2026-07-16 02:28:16 | gps_ping | V-003 | D-09 | R-02 | kurzeme | 63.4 | 23.5 |
| 2026-07-16 02:28:16 | gps_ping | V-041 | D-26 | R-10 | latgale | 48.2 | 25.9 |
| 2026-07-16 02:28:16 | gps_ping | V-022 | D-14 | R-14 | latgale | 71.3 | 30.6 |
| 2026-07-16 02:28:13 | gps_ping | V-049 | D-18 | R-05 | riga | 90.9 | 36.3 |
| 2026-07-16 02:28:13 | gps_ping | V-036 | D-12 | R-04 | vidzeme | 26.2 | 32.5 |
| 2026-07-16 02:28:10 | trip_start | V-049 | D-05 | R-13 | latgale | 52.7 | 33.4 |
| 2026-07-16 02:28:10 | gps_ping | V-013 | D-18 | R-11 | vidzeme | 92.7 | 15.7 |
| 2026-07-16 02:28:04 | speeding | V-045 | D-15 | R-01 | kurzeme | 83.9 | 9.6 |
| 2026-07-16 02:28:01 | gps_ping | V-022 | D-15 | R-09 | riga | 74.1 | 32 |
| 2026-07-16 02:27:58 | trip_end | V-003 | D-05 | R-12 | kurzeme | 48.9 | 29 |
| 2026-07-16 02:27:58 | gps_ping | V-007 | D-02 | R-13 | latgale | 71.6 | 15.3 |
| 2026-07-16 02:27:56 | gps_ping | V-034 | D-12 | R-05 | riga | 83.4 | 23.3 |