The Bottleneck

Our systems are constantly generating high-volume transactional events. In our case, these events are funneled through Kafka and ingested into InfluxDB. Each event includes details such as timestamps, categories, and other metadata. Initially, this architecture supported our analytical needs well. We used InfluxDB to store these metrics and performed queries to generate category-wise transaction reports.

Our typical reporting queries looked like this: