I just compared the query performance between ClickHouse and GreptimeDB. I’m not sure why GreptimeDB’s query performance is so poor.

thanks for your attention. for this specific query, we don’t pay much optimization on generic aggregation/AP query, as a time series database. If your scenario is to implement some pagination logic, our good practice is to implement as a “endless list”, similar grafana loki