mirror of
https://github.com/MeshCore-Beacon/beacon-server.git
synced 2026-09-25 05:04:22 +00:00
MrAlders0n
7650d9b742
GET /observers/{id}/activity returns bucketed observation counts, LoRa
airtime, SNR/RSSI aggregates and a payload-type breakdown for one
observer. Airtime is computed at ingest from the raw frame length and
stored on the observation; intervals of 1h and up are served from an
hourly matview so no request path joins back to packets.
3 lines
145 B
SQL
3 lines
145 B
SQL
-- Time-on-air per observation so per-observer activity never joins back to packets.
|
|
ALTER TABLE packet_observations ADD COLUMN airtime_ms REAL;
|