Fast SQL for time-series

Columnar open source time-series database with high performance ingestion and blazingly fast SQL analytics. Self-hosted or fully managed.

Get QuestDBChoose the right product

Performance

Ingest 2M rows/s per node
Up to 10x faster writes vs InfluxDB
Don’t worry about cardinality
Columnar storage
Data partitioned by time
SIMD-optimized queries

See Benchmarks

Developer experience

SQL time series extensions
Built-in SQL optimizer & REST API
PostgreSQL driver compatibility
InfluxDB Line Protocol API
SQL and time-series joins
Grafana integration

See live demo

Enterprise ready

TLS for all protocols
Hot & cold read replicas
Role-based access control
Multiple availability zones
Data compression
Enterprise support SLA

See Enterprise

Try the live demo

Query three large datasets and more than 2 billion rows in milliseconds with SQL

Try QuestDB demo in your browser

See query results >

Use QuestDB with the tools you love

Postgres Grafana Kafka Python Pandas Telegraf Spark Superset MindsDB Cube Redpanda Plotly

Augmented SQL for time series

QuestDB enhances ANSI SQL with time series extensions to manipulate 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”

Why time series?

Financial market data

Store years of market tick data to identify historical trends, and correlate it with orders and executed trades via ASOF joins. Monitor market activity in real-time, compute time-series charts and price candles on the fly. Open source kdb+ alternative.

Application metrics

Track and visualize user behavior data, API calls, data latency, and other application events and analytics in real-time.

Connected devices, IoT

Capture, store and respond to sensor data and telemetry at any resolution in industrial applications—process high cardinality data without hiccups.

Network traffic analysis

Ingest sFlow or other network traffic metadata leveraging QuestDB's native IPv4 type. Detect anomalies in real-time from blasts of networking data.

Machine learning with time-series data

Load Pandas DataFrames into QuestDB to the tune of millions of rows per second. Download data from QuestDB to train machine learning models.

AdTech

Monitor user activity by storing and analyzing Ad impressions, clicks, scrolls, and conversions in AdTech platforms.

Interactive Console

Interactive console to import data (drag and drop) and start querying right away.

Check our Web Console documentation to get started.

Artistic view of QuestDB's Web Console split in 3 components: the navigation tree, the SQL code editor and data displayed as a chart