PostgreSQL for time‑series

TimescaleDB is the leading open-source relational database for 
time-series data. Fully managed or self‑hosted.

Get Timescale
Supercharged PostgreSQL

Rely on the same PostgreSQL you know and love, with full SQL, rock-solid reliability, and a massive ecosystem.

Accelerated performance

Achieve 10-100x faster queries than PostgreSQL, InfluxDB, and MongoDB. Native optimizations for time-series.

Massive scale

Write millions of data points per second. Store 100s of terabytes or petabytes. Don’t worry about cardinality.

Relational & time series, together

Simplify your stack, ask more complex questions, and build more powerful applications.

Worry-free operations

Let us run TimescaleDB for you, fully managed on AWS, Azure, or GCP in 75+ regions. Access top-rated support.

Lower costs

Spend less with 94 - 97% compression rates from best-in-class algorithms and other performance improvements.

Cloud

A fully-managed, multi-cloud time-series database service powered by TimescaleDB and PostgreSQL. The fast, easy, and reliable way to store all your time-series data.

Learn more

Time-series data is everywhere

All monitoring data is time-series data. Efficiently finding and addressing infrastructure and application issues is a time-series problem. TimescaleDB helps you cost-effectively store and analyze data at scale to identify and predict performance anomalies and service outages, conduct post-mortems, and plan for future capacity needs. Whether you’re collecting home-grown monitoring data, Prometheus metrics, Kubernetes events, logs, or custom metrics, TimescaleDB enables you to measure what matters.

Product data is time-series data. Quickly understanding how your product is used over time, segmenting your customer base, and making product and business decisions is a time-series problem. Or use TimescaleDB to drive user-facing dashboards and analytics when your product is time-series data. TimescaleDB can store all of your application metrics at a fraction of the cost of an analytics service. Timescale gives you all the reliability and flexibility of PostgreSQL, meaning you can use full SQL to construct queries to better understand your products and delight your users.

Device and sensor data is time-series data. Tracking device performance with pinpoint geospatial and temporal accuracy is a time-series problem. TimescaleDB helps you cost-effectively store and analyze relentless streams of device telemetry and sensor readings at scale, in order to manage industrial equipment maintenance, fleet management, asset tracking, route planning, yield optimization, oil and gas production, and more.

Financial data is time-series data. Understanding market and tick data accurately and combining that data with other sources of information is a time-series problem and the foundation of modern financial analysis. TimescaleDB is PostgreSQL with superpowers, meaning you can easily track your time-series tick data, order books, and other market data in a proven database with rock-solid reliability, and correlate it with other relational trend data at your disposal using full SQL. From historical tick data to complex financial modeling, TimescaleDB can help you build insightful products.

-- What is the change of memory consumption for each
-- of my k8s containers over the past 10 minutes?
SELECT time_bucket('10 seconds', time) AS period,
  container_id, avg(free_mem)
FROM metrics
WHERE time > NOW () - interval '10 minutes'
GROUP BY period, container_id
ORDER BY period DESC, container_id;






| period                 | container_id | avg     |
|------------------------|--------------|---------|
| 2020-07-01 12:01:00+00 | 16           | 72202   |
| 2020-07-01 12:01:00+00 | 73           | 837725  |
| 2020-07-01 12:01:00+00 | 96           | 412237  |
| 2020-07-01 12:01:00+00 | 142          | 1173393 |
| 2020-07-01 12:00:50+00 | 16           | 90104   |
| 2020-07-01 12:00:50+00 | 73           | 784596  |
| 2020-07-01 12:00:50+00 | 96           | 574134  |
| 2020-07-01 12:00:50+00 | 142          | 960104  |




Built on PostgreSQL

Use the PostgreSQL tools and utilities you know and love

logo-chartio
logo-apache-airflow
logo-apache-airflow
logo-apache-airflow
logo-datadog
logo-apache-airflow
logo-collectd
logo-apache-airflow
logo-dbeaver
logo-apache-airflow
logo-dbglass
logo-apache-airflow
logo-grafana
logo-apache-airflow
logo-debezium
logo-apache-airflow
logo-hibernate
logo-apache-airflow
logo-kafka
logo-apache-airflow
logo-docker
logo-apache-airflow
logo-jackdb
logo-apache-airflow
logo-looker
logo-apache-airflow
logo-kubernetes
logo-apache-airflow
logo-periscope
logo-apache-airflow
Join the largest time-series developer community
543,710+ ACTIVE
TimescaleDB databases

Built by developers for developers

Tutorials
Read

Tutorials

Explore step-by-step tutorials to get a tour of TimescaleDB features, including built-in SQL functions, and run your first queries using a public dataset.

Explore the tutorials
Use continuous aggregates
Read

Use continuous aggregates

Follow this tutorial to use TimescaleDB's automated materialization capabilities to speed up your common aggregate queries.

Learn more
Timescale Blog
Read

Timescale Blog

Visit our blog to get our latest demos, tips and tricks, best practices for using time-series data, and updates about upcoming virtual events.

Explore the blog
Visualize your data with TimescaleDB and Grafana
Read

Visualize your data with TimescaleDB and Grafana

Learn how to set up, connect, and build your dashboards with TimescaleDB and Grafana (a popular open-source visualization tool).

Learn more
Set up TimescaleDB with Prometheus
Download

Set up TimescaleDB with Prometheus

Create analytical, long-term storage for Prometheus data in TimescaleDB with one command-line statement using our Helm charts.

Launch now
API Reference
Search

API Reference

Get in-depth knowledge about all of TimescaleDB’s features and how to use them.

Explore the docs

Learn more about TimescaleDB

Check out our Documentation

Go to the Timescale Docs