Fast SQL for time series

QuestDB is the fastest open source time series database

Query our demo dataset with 1.6 billion rows in milliseconds

docker pull questdb/questdb
docker run -p 9000:9000 questdb/questdb

Built for performance

SIMD optimised analytics

Rows and columns based access

Vectorized queries execution

Tiny memory footprint

C++ and zero-GC Java

A code editor with a chart that shows the result of the query

Optimized for time series

Relational model for time series

Data stored in chronological order

Time partitioned

Scalable ingestion

Immediate consistency

Fast InfluxDB line protocol

A code editor containing a SQL statement

Implemented with SQL

Time series and relational joins

Postgres compatibility

Aggregations and down sampling

Unlimited sub-queries

Built-in SQL optimizer

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 = '2020-06-14;1M';

-- Search time
SELECT timestamp, tempC
FROM sensors
WHERE timestamp = '2020-06-14;1M';

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

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

SELECT sensorName, tempC
FROM sensors
LATEST BY sensorName;

-- Navigate time
SELECT sensorName, tempC
FROM sensors
LATEST 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 by”

Merge Time

Join two tables based on timestamp where timestamps do not exactly match with “asof join”

Why QuestDB?

Reduce hardware costs

Contain operational complexity

Decrease development costs

Cloud native (AWS, Azure, GCP)

On premises or embedded

Streaming

Operational analytics / OLAP

Monitoring and observability

Predictive analytics

Active directory

High performance replication

High availability

Clustering

Enterprise security

Postgres compatible/API

Why time series?

DevOps monitoring

Collect metrics and events from your infrastructure (CPU, memory, networks, etc) and get real-time visibility into your entire stack.

Financial market data

Store market data to identify historical trends and correlations using statistical methods and generate trading signals.

Connected devices

Capture, store and respond to data from sensors at any resolution in industrial applications.

Application metrics

Empower users of your application to track and visualise logs, api calls and any application activity in real-time.

CRUD for time series

Allows easy changes in historical data through fully ACID support for CRUD APIs.

Integrated data

Pull together all your application, device, and infrastructure data for a complete, 360º view of all aspects of your business.

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

Postgres compatibility

Interact with QuestDB using the Postgres layer and any tool that connects to it.

Open source

QuestDB is open source. Follow us on GitHub. Watch the repo to get notified of further releases and new features!

Go to GitHub >Join Slack >