Company
Date Published
Author
Regan Kuchan
Word count
464
Language
English
Hacker News points
None

Summary

In this article, the author discusses various InfluxDB aggregation functions and TICK-stack related issues, workarounds, and best practices to improve query performance. The author explains that aggregation functions like `mean()` return epoch 0 if no specific timestamp is included in the query, and provides examples of how to include a time range in the `WHERE` clause to get accurate results. Additionally, the article offers tips on improving query performance by removing unnecessary clauses and using regular expressions in `SHOW TAG VALUES`. The author also mentions upcoming features and resources for users, including InfluxDB Enterprise Beta and virtual training seminars.