События (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:46:41 | gps_ping | V-004 | D-22 | R-09 | riga | 72.8 | 27.2 |
| 2026-07-16 02:46:38 | gps_ping | V-043 | D-01 | R-04 | vidzeme | 19.2 | 26.9 |
| 2026-07-16 02:46:36 | gps_ping | V-040 | D-20 | R-11 | vidzeme | 72.7 | 31.3 |
| 2026-07-16 02:46:35 | gps_ping | V-009 | D-20 | R-13 | latgale | 90.3 | 32.8 |
| 2026-07-16 02:46:34 | gps_ping | V-048 | D-26 | R-15 | riga | 37.9 | 24 |
| 2026-07-16 02:46:34 | gps_ping | V-004 | D-23 | R-10 | latgale | 25.6 | 28.2 |
| 2026-07-16 02:46:30 | gps_ping | V-001 | D-27 | R-01 | kurzeme | 73.2 | 33 |
| 2026-07-16 02:46:20 | trip_start | V-010 | D-15 | R-12 | kurzeme | 22.8 | 30.7 |
| 2026-07-16 02:46:16 | gps_ping | V-039 | D-20 | R-10 | latgale | 40.6 | 16.6 |
| 2026-07-16 02:46:15 | trip_start | V-016 | D-08 | R-05 | riga | 26.3 | 39.6 |
| 2026-07-16 02:46:13 | idle | V-033 | D-29 | R-15 | riga | 0 | 31.2 |
| 2026-07-16 02:46:06 | gps_ping | V-008 | D-15 | R-13 | latgale | 34.6 | 26.4 |
| 2026-07-16 02:46:05 | gps_ping | V-041 | D-26 | R-13 | latgale | 31.5 | 26.6 |
| 2026-07-16 02:46:05 | gps_ping | V-002 | D-11 | R-07 | riga | 81.2 | 35.3 |
| 2026-07-16 02:46:02 | gps_ping | V-010 | D-28 | R-04 | vidzeme | 55.9 | 24.2 |
| 2026-07-16 02:46:02 | gps_ping | V-030 | D-05 | R-12 | kurzeme | 55.8 | 12.2 |
| 2026-07-16 02:46:00 | trip_end | V-038 | D-12 | R-06 | vidzeme | 85.2 | 27.9 |
| 2026-07-16 02:46:00 | trip_start | V-038 | D-25 | R-04 | vidzeme | 53.9 | 29.2 |
| 2026-07-16 02:45:51 | trip_start | V-044 | D-25 | R-12 | kurzeme | 79.8 | 32.2 |
| 2026-07-16 02:45:51 | trip_start | V-002 | D-21 | R-02 | kurzeme | 91.9 | 35.8 |
| 2026-07-16 02:45:46 | gps_ping | V-023 | D-25 | R-02 | kurzeme | 84.3 | 33.8 |
| 2026-07-16 02:45:44 | gps_ping | V-020 | D-14 | R-01 | kurzeme | 22.3 | 24 |
| 2026-07-16 02:45:42 | gps_ping | V-017 | D-23 | R-05 | riga | 43.3 | 25.3 |
| 2026-07-16 02:45:41 | refuel | V-013 | D-24 | R-13 | latgale | 0 | 15.3 |
| 2026-07-16 02:45:38 | gps_ping | V-019 | D-07 | R-12 | kurzeme | 79.3 | 28.1 |
| 2026-07-16 02:45:37 | harsh_braking | V-030 | D-23 | R-03 | kurzeme | 80.2 | 11.9 |
| 2026-07-16 02:45:35 | harsh_braking | V-020 | D-21 | R-02 | kurzeme | 32.6 | 27.2 |
| 2026-07-16 02:45:32 | speeding | V-014 | D-13 | R-07 | riga | 36.8 | 37.2 |
| 2026-07-16 02:45:28 | gps_ping | V-008 | D-10 | R-10 | latgale | 53.7 | 27.4 |
| 2026-07-16 02:45:28 | harsh_braking | V-035 | D-12 | R-11 | vidzeme | 47.9 | 35.8 |
| 2026-07-16 02:45:25 | trip_end | V-044 | D-17 | R-15 | riga | 36.7 | 32 |
| 2026-07-16 02:45:22 | trip_end | V-042 | D-17 | R-01 | kurzeme | 48.9 | 34.1 |
| 2026-07-16 02:45:21 | gps_ping | V-033 | D-15 | R-13 | latgale | 42.1 | 26.5 |
| 2026-07-16 02:45:20 | trip_start | V-022 | D-18 | R-04 | vidzeme | 36.2 | 30.9 |
| 2026-07-16 02:45:18 | gps_ping | V-019 | D-25 | R-09 | riga | 84.3 | 31.2 |
| 2026-07-16 02:45:11 | gps_ping | V-009 | D-17 | R-14 | latgale | 85.2 | 40.3 |
| 2026-07-16 02:45:03 | gps_ping | V-029 | D-19 | R-07 | riga | 77.7 | 29.8 |
| 2026-07-16 02:44:57 | gps_ping | V-029 | D-15 | R-10 | latgale | 28.1 | 24.8 |
| 2026-07-16 02:44:57 | gps_ping | V-028 | D-23 | R-02 | kurzeme | 46.8 | 36.8 |
| 2026-07-16 02:44:52 | gps_ping | V-018 | D-04 | R-11 | vidzeme | 75.9 | 15.4 |
| 2026-07-16 02:44:51 | gps_ping | V-042 | D-25 | R-10 | latgale | 48.5 | 35 |
| 2026-07-16 02:44:49 | gps_ping | V-034 | D-25 | R-03 | kurzeme | 75.9 | 30 |
| 2026-07-16 02:44:44 | refuel | V-027 | D-08 | R-09 | riga | 0 | 30.4 |
| 2026-07-16 02:44:38 | idle | V-010 | D-27 | R-11 | vidzeme | 0 | 20.2 |
| 2026-07-16 02:44:37 | gps_ping | V-039 | D-11 | R-15 | riga | 51.1 | 10.3 |
| 2026-07-16 02:44:37 | trip_end | V-005 | D-06 | R-01 | kurzeme | 47.6 | 15.9 |
| 2026-07-16 02:44:37 | gps_ping | V-022 | D-10 | R-06 | vidzeme | 38.2 | 19 |
| 2026-07-16 02:44:36 | refuel | V-038 | D-23 | R-12 | kurzeme | 0 | 28.9 |
| 2026-07-16 02:44:36 | gps_ping | V-034 | D-08 | R-13 | latgale | 25.1 | 27.1 |
| 2026-07-16 02:44:36 | trip_start | V-002 | D-08 | R-01 | kurzeme | 30.7 | 31.1 |