All 7 RedisTimeSeries questions
More in RedisTimeSeries
What is RedisTimeSeries, and what kind of data is it specifically designed to handle? How do you add a new data point to a Redis time series, and how do you query a range of recent data? How do you configure automatic downsampling in RedisTimeSeries, where detailed recent data is aggregated into coarser summaries over time? How do you configure a retention period for a Redis time series so old data is automatically removed after a certain amount of time? How would you design a monitoring system architecture using RedisTimeSeries that efficiently handles both high frequency raw data ingestion and long term historical trend analysis? How does RedisTimeSeries handle labels and how can you use them to query across multiple related time series at once?
Advertisement
Redis › RedisTimeSeries

What aggregation functions are available when querying a range of data from a Redis time series, and how do you apply one during a query?

Intermediate

Answer

RedisTimeSeries supports aggregation functions including avg, sum, min, max, count, and several others, which you apply to a TS.RANGE query using the AGGREGATION clause along with a specified time bucket duration, letting you retrieve summarized data, such as the average value per hour, directly from a query rather than needing to calculate it yourself afterward.
TS.RANGE temperature_sensor1 - + AGGREGATION avg 3600000
Real-world example A dashboard displaying a chart of average hourly temperature over the past week retrieves this exact summarized data directly from a single TS.RANGE query using the avg aggregation, without needing any additional calculation in the application code.

Common follow-ups: What is the difference between applying aggregation during a query versus using a compaction rule?;How do you choose an appropriate bucket duration for a specific chart or report?

RedisTimeSeries;Data Types
All 7 RedisTimeSeries questions