События (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:16:10 | gps_ping | V-027 | D-01 | R-08 | latgale | 87.4 | 28.1 |
| 2026-07-16 01:16:09 | gps_ping | V-043 | D-08 | R-14 | latgale | 38.9 | 27.1 |
| 2026-07-16 01:16:07 | gps_ping | V-018 | D-12 | R-02 | kurzeme | 78.6 | 10.6 |
| 2026-07-16 01:16:07 | gps_ping | V-025 | D-02 | R-03 | kurzeme | 34.8 | 32.9 |
| 2026-07-16 01:16:06 | gps_ping | V-028 | D-20 | R-13 | latgale | 36.1 | 38 |
| 2026-07-16 01:16:06 | gps_ping | V-049 | D-13 | R-08 | latgale | 25.4 | 34.6 |
| 2026-07-16 01:16:04 | engine_fault | V-050 | D-21 | R-11 | vidzeme | 31.3 | 27.5 |
| 2026-07-16 01:16:02 | idle | V-019 | D-20 | R-14 | latgale | 0 | 27.4 |
| 2026-07-16 01:15:58 | gps_ping | V-001 | D-10 | R-11 | vidzeme | 59.7 | 29.2 |
| 2026-07-16 01:15:56 | gps_ping | V-014 | D-25 | R-15 | riga | 61.9 | 33.2 |
| 2026-07-16 01:15:55 | gps_ping | V-008 | D-09 | R-15 | riga | 39.7 | 23.7 |
| 2026-07-16 01:15:54 | gps_ping | V-036 | D-24 | R-04 | vidzeme | 30.6 | 27.1 |
| 2026-07-16 01:15:51 | gps_ping | V-017 | D-09 | R-03 | kurzeme | 41.6 | 27.2 |
| 2026-07-16 01:15:51 | gps_ping | V-011 | D-07 | R-01 | kurzeme | 38.5 | 16.9 |
| 2026-07-16 01:15:47 | gps_ping | V-037 | D-19 | R-03 | kurzeme | 43.7 | 32.9 |
| 2026-07-16 01:15:45 | gps_ping | V-027 | D-23 | R-10 | latgale | 68.9 | 29 |
| 2026-07-16 01:15:43 | idle | V-029 | D-27 | R-08 | latgale | 0 | 29.8 |
| 2026-07-16 01:15:41 | refuel | V-023 | D-30 | R-10 | latgale | 0 | 33.7 |
| 2026-07-16 01:15:41 | gps_ping | V-024 | D-22 | R-14 | latgale | 82.1 | 11.9 |
| 2026-07-16 01:15:39 | gps_ping | V-030 | D-15 | R-14 | latgale | 48.4 | 12.5 |
| 2026-07-16 01:15:37 | gps_ping | V-033 | D-12 | R-08 | latgale | 72.3 | 37.8 |
| 2026-07-16 01:15:35 | refuel | V-002 | D-04 | R-15 | riga | 0 | 33.4 |
| 2026-07-16 01:15:35 | idle | V-001 | D-03 | R-06 | vidzeme | 0 | 27 |
| 2026-07-16 01:15:30 | gps_ping | V-043 | D-04 | R-02 | kurzeme | 25 | 32.4 |
| 2026-07-16 01:15:22 | trip_end | V-019 | D-01 | R-12 | kurzeme | 84.4 | 28.8 |
| 2026-07-16 01:15:20 | gps_ping | V-044 | D-12 | R-03 | kurzeme | 71.3 | 27.4 |
| 2026-07-16 01:15:18 | gps_ping | V-032 | D-24 | R-04 | vidzeme | 53.7 | 15.4 |
| 2026-07-16 01:15:13 | gps_ping | V-026 | D-28 | R-09 | riga | 62.6 | 17 |
| 2026-07-16 01:15:12 | gps_ping | V-037 | D-08 | R-10 | latgale | 14 | 28.4 |
| 2026-07-16 01:15:09 | gps_ping | V-048 | D-06 | R-03 | kurzeme | 64 | 29 |
| 2026-07-16 01:15:06 | gps_ping | V-046 | D-01 | R-02 | kurzeme | 25.3 | 35.3 |
| 2026-07-16 01:15:03 | gps_ping | V-022 | D-07 | R-13 | latgale | 94.1 | 28.4 |
| 2026-07-16 01:15:00 | gps_ping | V-029 | D-21 | R-02 | kurzeme | 38.8 | 21.9 |
| 2026-07-16 01:14:56 | gps_ping | V-033 | D-06 | R-06 | vidzeme | 35.8 | 28.7 |
| 2026-07-16 01:14:55 | trip_start | V-046 | D-11 | R-02 | kurzeme | 58 | 30.1 |
| 2026-07-16 01:14:55 | gps_ping | V-010 | D-28 | R-10 | latgale | 56.2 | 25.8 |
| 2026-07-16 01:14:54 | gps_ping | V-035 | D-19 | R-08 | latgale | 65.5 | 30.1 |
| 2026-07-16 01:14:42 | gps_ping | V-041 | D-22 | R-07 | riga | 30.9 | 27.1 |
| 2026-07-16 01:14:40 | gps_ping | V-041 | D-28 | R-01 | kurzeme | 69.3 | 31.1 |
| 2026-07-16 01:14:38 | trip_end | V-013 | D-09 | R-15 | riga | 25.3 | 17.4 |
| 2026-07-16 01:14:36 | gps_ping | V-021 | D-26 | R-10 | latgale | 48.6 | 30 |
| 2026-07-16 01:14:34 | refuel | V-017 | D-28 | R-06 | vidzeme | 0 | 27.4 |
| 2026-07-16 01:14:31 | idle | V-004 | D-14 | R-14 | latgale | 0 | 26.6 |
| 2026-07-16 01:14:25 | refuel | V-014 | D-24 | R-11 | vidzeme | 0 | 34 |
| 2026-07-16 01:14:23 | gps_ping | V-004 | D-27 | R-02 | kurzeme | 90.5 | 27.3 |
| 2026-07-16 01:14:22 | gps_ping | V-031 | D-17 | R-09 | riga | 83.2 | 26.1 |
| 2026-07-16 01:14:17 | refuel | V-009 | D-10 | R-12 | kurzeme | 0 | 30.8 |
| 2026-07-16 01:14:16 | speeding | V-024 | D-08 | R-15 | riga | 36 | 15.6 |
| 2026-07-16 01:14:13 | gps_ping | V-009 | D-10 | R-09 | riga | 73.3 | 31.6 |
| 2026-07-16 01:14:13 | gps_ping | V-031 | D-07 | R-08 | latgale | 75.8 | 24.7 |