Approximation-First Timeseries Query At Scale
2025-06-01·
,,,·
0 min read
Zeying Zhu
Dr. Jonathan Chamberlain
Kenny Wu
David Starobinski
Zaoxing Liu
Abstract
Timeseries monitoring systems such as Prometheus play a crucial role in gaining observability of the underlying system components. These systems collect timeseries metrics from various system components and perform monitoring queries over periodic window-based aggregations (i.e., rule queries). However, despite wide adoption, the operational costs and query latency of rule queries remain high. In this paper, we identify major bottlenecks associated with repeated data scans and query computations concerning window overlaps in rule queries, and present PromSketch, an approximation-first query framework as intermediate caches for monitoring systems. It enables low operational costs and query latency, by combining approximate window-based query frameworks and sketch-based precomputation. PromSketch is implemented as a standalone module that can be integrated into Prometheus and VictoriaMetrics, covering 70% of Prometheus’ aggregation over time queries. Our evaluation shows that PromSketch achieves up to a \change{two orders of magnitude} reduction in query latency over Prometheus and VictoriaMetrics, while lowering operational dollar costs of query processing by two orders of magnitude compared to Prometheus and by at least 4 times compared to VictoriaMetrics with at most 5% average errors across statistics. The source code, data, and/or other artifacts^(n.b.) have been made available at https://github.com/Froot-NetSys/promsketch. (n.b.":" The artifacts in question are the products of the FROOT Lab at the University of Maryland, and are under the authorship of Zeying Zhu and Kenny Wu; the repository link is provided on this webpage as reference given the primary contribution of this work is the PromSketch code itself, and should not be construed as my own personal contribution to this project.)
Type
Publication
Proceedings of the VLDB Endowment

Authors
Dr. Jonathan Chamberlain
(he/him)
Unaffiliated Researcher
As a Graduate Research Fellow with BU NISLAB, I published a number of papers, including a paper in collaboration with the Ohio State ElectroScience Laboratory stablishing the economic feasibility of sharing for wholesale commercial markets yielding priority to mission critical Earth Exploration Satellite Service-passive (EESS-passive) radiometers which received the Runner-Up accolade for Best Paper on the Policy Track at IEEE DySpan 2024. I was also actively involved in multiple service roles, including serving on the executive board of the Boston University Student Association of Graduate Engineers in various roles, membering on an advisory committee providing feedback for university initiatives and proposed policy updates to the Associate Provost for Graduate Affairs, and co-organized the 10th and 11th editions of the BU Center for Information and Systems Engineering Graduate Student Workshops in 2024 and 2025. For these efforts, as well as my work mentoring students both within the NISLAB and in other projects as well as my published research, I was recognized with the BU ECE Department Doctoral Acheivement Award for the 2024-25 academic year. I additionally had the privilege of participating in the 2025 NSF NeTS Early Career Investigators workshop.