События (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:52:24 | gps_ping | V-040 | D-14 | R-06 | vidzeme | 34.8 | 35.1 |
| 2026-07-16 01:52:22 | gps_ping | V-021 | D-09 | R-02 | kurzeme | 63.8 | 33.4 |
| 2026-07-16 01:52:16 | gps_ping | V-012 | D-24 | R-14 | latgale | 40.5 | 29 |
| 2026-07-16 01:52:14 | speeding | V-032 | D-06 | R-11 | vidzeme | 21.9 | 14 |
| 2026-07-16 01:52:14 | gps_ping | V-045 | D-08 | R-15 | riga | 76.2 | 16.5 |
| 2026-07-16 01:52:13 | gps_ping | V-026 | D-17 | R-15 | riga | 52.4 | 12.3 |
| 2026-07-16 01:52:10 | gps_ping | V-025 | D-03 | R-11 | vidzeme | 31.8 | 36.2 |
| 2026-07-16 01:52:09 | gps_ping | V-014 | D-25 | R-10 | latgale | 49.5 | 38.1 |
| 2026-07-16 01:52:08 | engine_fault | V-010 | D-14 | R-13 | latgale | 36.8 | 34.5 |
| 2026-07-16 01:51:56 | refuel | V-013 | D-24 | R-03 | kurzeme | 0 | 15.6 |
| 2026-07-16 01:51:54 | speeding | V-029 | D-19 | R-12 | kurzeme | 47.5 | 26.3 |
| 2026-07-16 01:51:51 | speeding | V-043 | D-30 | R-14 | latgale | 86.2 | 25.2 |
| 2026-07-16 01:51:42 | trip_end | V-044 | D-14 | R-06 | vidzeme | 70.1 | 29.9 |
| 2026-07-16 01:51:41 | refuel | V-004 | D-03 | R-11 | vidzeme | 0 | 27.4 |
| 2026-07-16 01:51:39 | refuel | V-024 | D-23 | R-13 | latgale | 0 | 12.7 |
| 2026-07-16 01:51:38 | gps_ping | V-048 | D-29 | R-05 | riga | 56.8 | 26.3 |
| 2026-07-16 01:51:37 | gps_ping | V-042 | D-21 | R-02 | kurzeme | 64.9 | 29.4 |
| 2026-07-16 01:51:35 | gps_ping | V-037 | D-11 | R-08 | latgale | 86.7 | 30.7 |
| 2026-07-16 01:51:30 | speeding | V-010 | D-09 | R-11 | vidzeme | 66.1 | 22.6 |
| 2026-07-16 01:51:29 | trip_end | V-023 | D-26 | R-02 | kurzeme | 32.4 | 31.7 |
| 2026-07-16 01:51:28 | speeding | V-048 | D-04 | R-09 | riga | 79.6 | 30.3 |
| 2026-07-16 01:51:25 | trip_start | V-020 | D-18 | R-02 | kurzeme | 65.9 | 25.5 |
| 2026-07-16 01:51:21 | gps_ping | V-050 | D-24 | R-02 | kurzeme | 56.6 | 27 |
| 2026-07-16 01:51:16 | gps_ping | V-050 | D-01 | R-10 | latgale | 27.7 | 26.3 |
| 2026-07-16 01:51:15 | trip_start | V-030 | D-08 | R-01 | kurzeme | 32.2 | 12 |
| 2026-07-16 01:51:12 | trip_start | V-023 | D-12 | R-11 | vidzeme | 89.3 | 28 |
| 2026-07-16 01:51:08 | gps_ping | V-008 | D-30 | R-12 | kurzeme | 70.1 | 28.3 |
| 2026-07-16 01:51:05 | gps_ping | V-005 | D-01 | R-04 | vidzeme | 63.8 | 9.4 |
| 2026-07-16 01:51:03 | gps_ping | V-035 | D-16 | R-10 | latgale | 75.7 | 28.5 |
| 2026-07-16 01:51:02 | gps_ping | V-020 | D-22 | R-12 | kurzeme | 27.8 | 28.5 |
| 2026-07-16 01:51:00 | gps_ping | V-022 | D-10 | R-10 | latgale | 80.1 | 26.5 |
| 2026-07-16 01:50:59 | gps_ping | V-041 | D-14 | R-04 | vidzeme | 19.2 | 31.4 |
| 2026-07-16 01:50:58 | trip_start | V-031 | D-04 | R-14 | latgale | 61.9 | 30.2 |
| 2026-07-16 01:50:54 | trip_end | V-027 | D-02 | R-15 | riga | 31.5 | 24.7 |
| 2026-07-16 01:50:53 | gps_ping | V-005 | D-16 | R-08 | latgale | 66.8 | 11.8 |
| 2026-07-16 01:50:52 | gps_ping | V-044 | D-03 | R-08 | latgale | 83.2 | 29.9 |
| 2026-07-16 01:50:51 | gps_ping | V-034 | D-05 | R-02 | kurzeme | 96 | 33.9 |
| 2026-07-16 01:50:49 | gps_ping | V-007 | D-19 | R-03 | kurzeme | 63.2 | 15.2 |
| 2026-07-16 01:50:41 | idle | V-030 | D-08 | R-09 | riga | 0 | 12.3 |
| 2026-07-16 01:50:40 | idle | V-016 | D-29 | R-04 | vidzeme | 0 | 36.4 |
| 2026-07-16 01:50:35 | refuel | V-002 | D-23 | R-14 | latgale | 0 | 46.2 |
| 2026-07-16 01:50:31 | gps_ping | V-040 | D-16 | R-07 | riga | 56.1 | 30 |
| 2026-07-16 01:50:31 | trip_start | V-049 | D-25 | R-06 | vidzeme | 66.6 | 28.7 |
| 2026-07-16 01:50:30 | harsh_braking | V-002 | D-05 | R-07 | riga | 69.1 | 31.5 |
| 2026-07-16 01:50:26 | engine_fault | V-030 | D-15 | R-14 | latgale | 48.9 | 15 |
| 2026-07-16 01:50:21 | gps_ping | V-009 | D-21 | R-07 | riga | 76.2 | 30.3 |
| 2026-07-16 01:50:16 | gps_ping | V-041 | D-07 | R-15 | riga | 63.2 | 29.9 |
| 2026-07-16 01:50:16 | gps_ping | V-023 | D-30 | R-12 | kurzeme | 30.8 | 37.2 |
| 2026-07-16 01:50:11 | gps_ping | V-033 | D-22 | R-03 | kurzeme | 98.1 | 26.4 |
| 2026-07-16 01:50:10 | trip_end | V-045 | D-12 | R-14 | latgale | 61.4 | 16.3 |