События (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:56:59 | gps_ping | V-028 | D-15 | R-12 | kurzeme | 46.7 | 38.9 |
| 2026-07-16 02:56:55 | trip_end | V-050 | D-06 | R-11 | vidzeme | 60.7 | 33.2 |
| 2026-07-16 02:56:55 | gps_ping | V-030 | D-15 | R-14 | latgale | 33.1 | 13.1 |
| 2026-07-16 02:56:54 | gps_ping | V-009 | D-28 | R-03 | kurzeme | 81.7 | 30.9 |
| 2026-07-16 02:56:50 | gps_ping | V-045 | D-07 | R-01 | kurzeme | 61.5 | 13.6 |
| 2026-07-16 02:56:47 | engine_fault | V-004 | D-02 | R-01 | kurzeme | 47.4 | 32.9 |
| 2026-07-16 02:56:46 | trip_start | V-017 | D-10 | R-02 | kurzeme | 34.7 | 21.6 |
| 2026-07-16 02:56:45 | idle | V-026 | D-18 | R-08 | latgale | 0 | 15.3 |
| 2026-07-16 02:56:41 | refuel | V-010 | D-12 | R-13 | latgale | 0 | 32.2 |
| 2026-07-16 02:56:41 | trip_end | V-007 | D-07 | R-01 | kurzeme | 73 | 17.5 |
| 2026-07-16 02:56:40 | gps_ping | V-018 | D-18 | R-11 | vidzeme | 76.8 | 14.3 |
| 2026-07-16 02:56:37 | speeding | V-048 | D-03 | R-10 | latgale | 40.4 | 22.6 |
| 2026-07-16 02:56:33 | gps_ping | V-049 | D-04 | R-03 | kurzeme | 30.8 | 28.5 |
| 2026-07-16 02:56:32 | gps_ping | V-037 | D-08 | R-02 | kurzeme | 104.7 | 29.6 |
| 2026-07-16 02:56:29 | gps_ping | V-020 | D-01 | R-10 | latgale | 43.8 | 32 |
| 2026-07-16 02:56:28 | trip_start | V-045 | D-26 | R-13 | latgale | 51.1 | 15.5 |
| 2026-07-16 02:56:24 | gps_ping | V-031 | D-04 | R-12 | kurzeme | 43.1 | 27.1 |
| 2026-07-16 02:56:24 | gps_ping | V-007 | D-20 | R-15 | riga | 49.5 | 13.6 |
| 2026-07-16 02:56:22 | gps_ping | V-037 | D-30 | R-12 | kurzeme | 82.7 | 31.6 |
| 2026-07-16 02:56:20 | trip_start | V-017 | D-12 | R-09 | riga | 49 | 26.5 |
| 2026-07-16 02:56:20 | gps_ping | V-001 | D-12 | R-07 | riga | 81.3 | 28.8 |
| 2026-07-16 02:56:18 | trip_start | V-039 | D-19 | R-02 | kurzeme | 71.6 | 13.3 |
| 2026-07-16 02:56:16 | engine_fault | V-014 | D-12 | R-01 | kurzeme | 51.3 | 33.7 |
| 2026-07-16 02:56:12 | trip_end | V-006 | D-15 | R-01 | kurzeme | 50.7 | 29.5 |
| 2026-07-16 02:56:11 | refuel | V-028 | D-20 | R-09 | riga | 0 | 32 |
| 2026-07-16 02:56:09 | refuel | V-012 | D-20 | R-13 | latgale | 0 | 25.4 |
| 2026-07-16 02:56:03 | trip_start | V-018 | D-07 | R-08 | latgale | 35.9 | 14.7 |
| 2026-07-16 02:56:01 | gps_ping | V-027 | D-24 | R-11 | vidzeme | 83.9 | 28.9 |
| 2026-07-16 02:56:00 | gps_ping | V-026 | D-15 | R-15 | riga | 77.8 | 12.8 |
| 2026-07-16 02:56:00 | gps_ping | V-024 | D-02 | R-15 | riga | 50.6 | 18.2 |
| 2026-07-16 02:56:00 | trip_start | V-018 | D-24 | R-15 | riga | 62.6 | 12.5 |
| 2026-07-16 02:55:59 | trip_start | V-028 | D-29 | R-13 | latgale | 55.8 | 36.3 |
| 2026-07-16 02:55:57 | gps_ping | V-031 | D-01 | R-12 | kurzeme | 93.5 | 29.3 |
| 2026-07-16 02:55:54 | idle | V-001 | D-29 | R-02 | kurzeme | 0 | 28.2 |
| 2026-07-16 02:55:54 | gps_ping | V-048 | D-04 | R-06 | vidzeme | 89.7 | 29.9 |
| 2026-07-16 02:55:47 | gps_ping | V-017 | D-25 | R-07 | riga | 30.3 | 29.6 |
| 2026-07-16 02:55:46 | refuel | V-045 | D-26 | R-02 | kurzeme | 0 | 18.5 |
| 2026-07-16 02:55:46 | gps_ping | V-003 | D-25 | R-14 | latgale | 41.6 | 25.1 |
| 2026-07-16 02:55:43 | refuel | V-026 | D-16 | R-08 | latgale | 0 | 9.9 |
| 2026-07-16 02:55:40 | speeding | V-046 | D-25 | R-10 | latgale | 62.6 | 25.9 |
| 2026-07-16 02:55:40 | gps_ping | V-033 | D-08 | R-03 | kurzeme | 17.3 | 30 |
| 2026-07-16 02:55:39 | gps_ping | V-048 | D-30 | R-10 | latgale | 37.2 | 23.8 |
| 2026-07-16 02:55:34 | gps_ping | V-017 | D-20 | R-13 | latgale | 52 | 25.1 |
| 2026-07-16 02:55:30 | gps_ping | V-011 | D-16 | R-05 | riga | 26.5 | 14.4 |
| 2026-07-16 02:55:27 | gps_ping | V-038 | D-21 | R-04 | vidzeme | 56.8 | 30.6 |
| 2026-07-16 02:55:24 | gps_ping | V-027 | D-16 | R-06 | vidzeme | 45.9 | 26.6 |
| 2026-07-16 02:55:14 | gps_ping | V-024 | D-23 | R-10 | latgale | 74.9 | 12.5 |
| 2026-07-16 02:55:12 | gps_ping | V-024 | D-26 | R-13 | latgale | 71.7 | 18.5 |
| 2026-07-16 02:55:12 | gps_ping | V-034 | D-17 | R-13 | latgale | 77 | 30.2 |
| 2026-07-16 02:55:05 | gps_ping | V-001 | D-24 | R-13 | latgale | 48 | 25.2 |