High performance time series database

For massive volumes of time-series data, trust a specialized time-series database. Timestamps are first-class, and blistering throughput is sustained even through the highest data cardinality. Deduplication and out-of-order ingestion also work right out-of-the-box.

Read the docs

“QuestDB outperforms every database we have tested and delivered a 10x improvement in querying speed. It has become a critical piece of our infrastructure.”

Ahmad Abbasi — Co-founder and CEO

QuestDB performance compared to TimescaleDB and InfluxDB. QuestDB is the clear winner.

QuestDB is a time series database truly built by developers for developers. We found that QuestDB provides a unicorn solution to handle extreme TPS while also offering a simplified SQL programming interface.

>Viet Lee
CTO, Aquis Exchange

Augmented SQL for time series data

ANSI SQL time series extensions made for time stamped data

SELECT timestamp, tempC
FROM sensors
WHERE timestamp IN '2021-05-14;1M';

-- Search time
SELECT timestamp, tempC
FROM sensors
WHERE timestamp IN '2021-05-14;1M';

SELECT timestamp, avg(tempC)
FROM sensors
SAMPLE BY 5m;

-- Slice time
SELECT timestamp, avg(tempC)
FROM sensors
SAMPLE BY 5m;

SELECT timestamp, sensorName, tempC
FROM sensors
LATEST ON timestamp PARTITION BY sensorName;

-- Navigate time
SELECT timestamp, sensorName, tempC
FROM sensors
LATEST ON timestamp PARTITION BY sensorName;

SELECT sensors.timestamp ts, rain1H
FROM sensors
ASOF JOIN weather;

-- Merge time
SELECT sensors.timestamp ts, rain1H
FROM sensors
ASOF JOIN weather;

Search Time

Filter and search for specific timestamps with “WHERE”

Slice Time

Create time buckets and aggregate by intervals with “SAMPLE BY”

Navigate Time

Search time series from most recent values to oldest with “LATEST ON”

Merge Time

Join two tables based on timestamp where timestamps do not exactly match with “ASOF JOIN”

QuestDB is used at Airbus for real-time applications involving hundreds of millions of data points per day. For us, QuestDB is an outstanding solution that meets (and exceeds) our performance requirements.

>Oliver Pfeiffer
Software Architect, Airbus

Available in three flavours

Open Source, Enterprise, Cloud

Deploy QuestDB in the cloud, on-premises or on your laptop.

Open source: Always open source. QuestDB is licensed under Apache 2.0, for worry-free, developer-friendly usage.
QuestDB Cloud: Affordable managed clusters with replication, backups and monitoring. Trust the expert QuestDB team.
Enterprise: Premium features like Role-based Access Control and database replication means scale on your own terms.

Switching to QuestDB was a game-changer for our analytics. With Elasticsearch, we faced slow ingestion and latency issues for queries. With QuestDB, we now process 500M records per day smoothly.

>Ajay Pilaniya
Lead Media Analytics, Airtel

Ready to upgrade?

Break free from ingestion speed bottlenecks

Spin up in minutes.

Get QuestDB

High performance time series database

Performance

Developer experience

Enterprise ready

Try the live demo

Use QuestDB with the tools you love

Peak performance time-series

Augmented SQL for time series data

Magnifying glass iconSearch Time

Knife iconSlice Time