Values in extra_info_bandwidth_history do not match the descriptor values
Having a table with parsed bandwidth values is nice, but right now it seems the values are not matching up to the original descriptor values. I have the following two queries:
SELECT published, read_history, write_history FROM extra_info_descriptor WHERE fingerprint = "46BACCCE4BC3CAA63D2FE770DA2AE3CF401B9CF0" AND published between (%s) AND (%s) ORDER BY published ASC
SELECT published, time, read_bandwidth_value, write_bandwidth_value FROM extra_info_bandwidth_history WHERE fingerprint = "46BACCCE4BC3CAA63D2FE770DA2AE3CF401B9CF0" AND published between (%s) AND (%s) ORDER BY time ASC
When requesting results between 2024-10-29 - 2024-11-01 I get:
+------------------------------------------+------------------------------------------+------------------------------------------+
| published | read_history | write_history |
+------------------------------------------+------------------------------------------+------------------------------------------+
| 2024-10-29 17:55:45 | {"line":"read-history 2024-10-28 19:29:47 (86400 s) 726713942016,757250898944,905751416832,1049383814144,1107215567872","historyEndMillis":1730143787000,"intervalLength":86400,"bandwidthValues":{"1729798187000":726713942016,"1729884587000":757250898944,"1729970987000":905751416832,"1730057387000":1049383814144,"1730143787000":1107215567872}} | {"line":"write-history 2024-10-28 19:29:47 (86400 s) 650457216000,681311864832,831436703744,976918665216,1034752924672","historyEndMillis":1730143787000,"intervalLength":86400,"bandwidthValues":{"1729798187000":650457216000,"1729884587000":681311864832,"1729970987000":831436703744,"1730057387000":976918665216,"1730143787000":1034752924672}} |
+------------------------------------------+------------------------------------------+------------------------------------------+
and
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
| published | time | read_bandwidth_value | write_bandwidth_value |
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
| 2024-10-29 04:00:00 | 2024-10-23 19:29:47 | 545664802816 | 469847328768 |
| 2024-10-29 04:00:00 | 2024-10-24 19:29:47 | 726714044416 | 650457325568 |
| 2024-10-29 04:00:00 | 2024-10-25 19:29:47 | 757251031040 | 681311993856 |
| 2024-10-29 04:00:00 | 2024-10-26 19:29:47 | 905751533568 | 831436852224 |
| 2024-10-29 04:00:00 | 2024-10-27 19:29:47 | 1049383838720 | 976918684672 |
+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
What I'd expect instead is:
- the
published
values are matching, showing the extra-info desc one - the
read_bandwidth_value
s andwrite_bandwidth_value
s match their respective descriptor values -
time
would be from2024-10-24 19:29:47
to2024-10-28 19:29:47
instead.
Edited by Georg Koppen