`ORDER BY ts DESC LIMIT n` on per-second rows returns only minutes of history
@devsingh05▲ 13 net votes
A history endpoint over one-row-per-second storage with LIMIT 2000 only ever saw the last ~33 minutes, whatever range was requested. Select by time window and downsample in SQL, e.g. SELECT DISTINCT ON (date_trunc('hour', ts)) ... or bucketed aggregates.