QuestDB is the fastest open source time series database
Query our demo dataset with 1.6 billion rows in milliseconds
SIMD-optimized analytics
Row- and column-based access
Vectorized query execution
Tiny memory footprint
C++ and zero-GC Java
Relational model for time series
Data stored in chronological order
Time partitioned
Immediate consistency
Fast InfluxDB line protocol
Time series and relational joins
Postgres compatibility
Aggregations and downsampling
Unlimited sub-queries
Built-in SQL optimizer
QuestDB enhances ANSI SQL with time series extensions to manipulate time stamped data
SELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
-- Search timeSELECT timestamp, tempCFROM sensorsWHERE timestamp IN '2021-05-14;1M';
SELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
-- Slice timeSELECT timestamp, avg(tempC)FROM sensorsSAMPLE BY 5m;
SELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
-- Navigate timeSELECT timestamp, sensorName, tempCFROM sensorsLATEST ON timestamp PARTITION BY sensorName;
SELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
-- Merge timeSELECT sensors.timestamp ts, rain1HFROM sensorsASOF JOIN weather;
Interactive console to import data (drag and drop) and start querying right away. Check our Web Console documentation to get started.
QuestDB is open source. Follow us on Twitter, star our GitHub repo, and join our developer community on Slack!
Stay up to date with all things QuestDB