Query Planning Overhead with Many Chunks (And How to Fix It)

The Hidden Cost of TimescaleDB Chunks: Query Planning Time I spent an entire afternoon trying to figure out why a trivial aggregation query was taking 500ms on a well-indexed TimescaleDB hypertable. EXPLAIN ANALYZE showed 2ms of execution. The indexe...