Table 1012 (TSFIXBIN)

continuousReport, thing RoboC-APG1-CP #200160 RoboC-APG1-FW, pattern 4503599627370580 / 272 bits, THING → SERVER
1 tick = 1 s, a window of 1036800 ticks
window 5613: 1036800 ticks, 2020-10-17 00:00:00.000000 .. 2020-10-28 23:59:59.000000 UTC
newest row (cached): -, limitRows 0 (UNSHIFT)
auto add
imported from the first server, aTlmtList #1012

File data/db-5613-TSFIXBIN.bin: 662 rows, 24494 bytes
row = 34 bytes data + ts (ticks 0..1036799) = 37 bytes, writes allowed into the last 500 rows

Write actions are disabled (debug = false).

Windows (3)

window = filetimestampStarttimestampEndticksnewest row (cached)file bytes
56132020-10-17 00:00:00.0000002020-10-28 23:59:59.0000001036800-24494
56122020-10-05 00:00:00.0000002020-10-16 23:59:59.0000001036800-443075
10122020-09-23 00:00:00.0000002020-10-04 23:59:59.0000001036800-208199

Last 10 rows

tstime, UTCdata (hex)
4432842020-10-22 03:08:04.0000005801000000800c002000000000002800c03f0000c00000e03d0000e0605318ff0301
4432852020-10-22 03:08:05.0000005a01000000800c002000000000000c00c03f0000c00000e03d000060605318ff0301
4432862020-10-22 03:08:06.0000005a01000000800c002000000000001600c03f0000c00000e03d000080605318ff0301
4432872020-10-22 03:08:07.0000005c01000000800c002000000000000800c03f0000c00000e03d000040605318ff0301
4619262020-10-22 08:18:46.0000004101000000800c002000000000000a00c03f0000c00000e03d000090607d18ff0301
4619272020-10-22 08:18:47.0000004101000000800c002000000000003c00c03f0000c00000e03d0000e8607d18ff0301
4619282020-10-22 08:18:48.0000004201000000800c002000000000000800c03f0000c00000e03d000040607d18ff0301
5368422020-10-23 05:07:22.000000050000006400d90cc4800dc640079c0bc03f0000001800a000000c30bb90ac0214c3
5368432020-10-23 05:07:23.000000050000006400d90cc4800dc64007980bc03f0000001800a000000e20bb90ac0216c3
5368442020-10-23 05:07:24.000000070000006400d90cc4800dc64007a80bc03f00000017b0a000000e40bb90ac0316c3

Read

Row from end
Rows with ts > and ts ≥ , limit