События (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 00:57:58 | idle | V-001 | D-03 | R-07 | riga | 0 | 32.8 |
| 2026-07-16 00:57:57 | idle | V-028 | D-12 | R-13 | latgale | 0 | 30.3 |
| 2026-07-16 00:57:47 | gps_ping | V-021 | D-17 | R-11 | vidzeme | 27 | 33.6 |
| 2026-07-16 00:57:45 | gps_ping | V-003 | D-20 | R-15 | riga | 72.9 | 24.8 |
| 2026-07-16 00:57:41 | speeding | V-014 | D-28 | R-06 | vidzeme | 24.2 | 33.7 |
| 2026-07-16 00:57:37 | refuel | V-013 | D-07 | R-08 | latgale | 0 | 11.6 |
| 2026-07-16 00:57:37 | gps_ping | V-042 | D-25 | R-09 | riga | 68.9 | 34.4 |
| 2026-07-16 00:57:32 | gps_ping | V-006 | D-09 | R-10 | latgale | 57.1 | 28.9 |
| 2026-07-16 00:57:29 | harsh_braking | V-021 | D-04 | R-13 | latgale | 34.9 | 38.3 |
| 2026-07-16 00:57:26 | gps_ping | V-013 | D-12 | R-05 | riga | 79 | 21 |
| 2026-07-16 00:57:24 | gps_ping | V-013 | D-23 | R-04 | vidzeme | 30.2 | 21.6 |
| 2026-07-16 00:57:21 | gps_ping | V-017 | D-22 | R-09 | riga | 56.2 | 27.8 |
| 2026-07-16 00:57:19 | gps_ping | V-024 | D-05 | R-07 | riga | 26.6 | 17.7 |
| 2026-07-16 00:57:16 | trip_end | V-037 | D-13 | R-10 | latgale | 98.1 | 31.7 |
| 2026-07-16 00:57:11 | harsh_braking | V-046 | D-07 | R-08 | latgale | 64.4 | 26.8 |
| 2026-07-16 00:57:10 | trip_start | V-047 | D-13 | R-04 | vidzeme | 91.1 | 14.6 |
| 2026-07-16 00:57:08 | gps_ping | V-022 | D-15 | R-04 | vidzeme | 64.5 | 23.8 |
| 2026-07-16 00:57:05 | gps_ping | V-024 | D-03 | R-11 | vidzeme | 66 | 17.6 |
| 2026-07-16 00:57:04 | gps_ping | V-038 | D-25 | R-02 | kurzeme | 33.3 | 31.3 |
| 2026-07-16 00:56:52 | trip_start | V-036 | D-19 | R-06 | vidzeme | 58.8 | 25.5 |
| 2026-07-16 00:56:45 | trip_start | V-038 | D-20 | R-14 | latgale | 47.5 | 32.3 |
| 2026-07-16 00:56:44 | gps_ping | V-014 | D-27 | R-06 | vidzeme | 26.5 | 27.6 |
| 2026-07-16 00:56:44 | trip_end | V-020 | D-05 | R-05 | riga | 39.9 | 25.5 |
| 2026-07-16 00:56:44 | gps_ping | V-007 | D-11 | R-10 | latgale | 67.4 | 10.6 |
| 2026-07-16 00:56:36 | speeding | V-012 | D-01 | R-14 | latgale | 71.2 | 30.7 |
| 2026-07-16 00:56:34 | engine_fault | V-025 | D-11 | R-09 | riga | 76.3 | 28.9 |
| 2026-07-16 00:56:33 | gps_ping | V-021 | D-13 | R-08 | latgale | 73.1 | 32.4 |
| 2026-07-16 00:56:33 | gps_ping | V-033 | D-04 | R-04 | vidzeme | 20.6 | 24.1 |
| 2026-07-16 00:56:32 | idle | V-004 | D-02 | R-11 | vidzeme | 0 | 33.4 |
| 2026-07-16 00:56:32 | gps_ping | V-005 | D-29 | R-03 | kurzeme | 32.7 | 14.5 |
| 2026-07-16 00:56:31 | engine_fault | V-043 | D-15 | R-08 | latgale | 63.8 | 29.8 |
| 2026-07-16 00:56:31 | gps_ping | V-037 | D-14 | R-03 | kurzeme | 34.3 | 32.4 |
| 2026-07-16 00:56:29 | trip_start | V-049 | D-23 | R-07 | riga | 70 | 42.9 |
| 2026-07-16 00:56:27 | trip_end | V-040 | D-18 | R-15 | riga | 39.9 | 25.6 |
| 2026-07-16 00:56:21 | refuel | V-042 | D-10 | R-14 | latgale | 0 | 45.8 |
| 2026-07-16 00:56:19 | gps_ping | V-011 | D-29 | R-03 | kurzeme | 42.9 | 13.1 |
| 2026-07-16 00:56:14 | harsh_braking | V-038 | D-29 | R-13 | latgale | 74 | 28 |
| 2026-07-16 00:56:14 | trip_start | V-025 | D-17 | R-03 | kurzeme | 30.1 | 30.3 |
| 2026-07-16 00:56:11 | harsh_braking | V-010 | D-03 | R-03 | kurzeme | 42.1 | 26.7 |
| 2026-07-16 00:56:08 | gps_ping | V-009 | D-09 | R-06 | vidzeme | 67.3 | 34.3 |
| 2026-07-16 00:56:08 | gps_ping | V-023 | D-14 | R-10 | latgale | 76.2 | 36.6 |
| 2026-07-16 00:56:04 | trip_start | V-042 | D-14 | R-07 | riga | 54 | 33.5 |
| 2026-07-16 00:55:56 | idle | V-046 | D-17 | R-04 | vidzeme | 0 | 30.7 |
| 2026-07-16 00:55:55 | speeding | V-010 | D-21 | R-15 | riga | 62.4 | 26.8 |
| 2026-07-16 00:55:52 | gps_ping | V-039 | D-04 | R-10 | latgale | 30.4 | 14.8 |
| 2026-07-16 00:55:51 | speeding | V-026 | D-05 | R-11 | vidzeme | 32 | 16 |
| 2026-07-16 00:55:50 | engine_fault | V-014 | D-28 | R-06 | vidzeme | 37.5 | 32 |
| 2026-07-16 00:55:49 | harsh_braking | V-027 | D-10 | R-04 | vidzeme | 49.3 | 31.8 |
| 2026-07-16 00:55:48 | gps_ping | V-020 | D-02 | R-15 | riga | 73.5 | 21.9 |
| 2026-07-16 00:55:46 | gps_ping | V-042 | D-04 | R-04 | vidzeme | 52.6 | 35.3 |