TimescaleDB

All of your
time-series data,
instantly accessible

TimescaleDB: An open-source database built for analyzing
time-series data with the power and convenience of
SQL — on premise, at the edge or in the cloud.

Try TimescaleDB for FREE in the Cloud
Rich time-series analytics
Rich time-series analytics

Built-in tools to perform common time-series data analysis, including buckets, gap filling, aggregations, and more.

Convenience of SQL
Convenience of SQL

Get started right away using the query language your developers and business analysts already know.

Massive scale and performance
Massive scale and performance

Write millions of data points per second. Store 100s of billions of rows and 10s of terabytes of data.

Power of PostgreSQL
Powered by PostgreSQL

Leverage the reliability, maturity, and operational efficiency of one of the world's most popular databases.

What is time-series data?
What is time-series data?

Learn more about what time-series
data is and why it matters.

Learn more
Why TimescaleDB?
Why TimescaleDB?

Get a better understanding of how
TimescaleDB works.

Learn more

Timescale Cloud

A fully-managed, multi-cloud time-series database
service powered by TimescaleDB.

Learn More

Time-series data is everywhere

Leverage the insights hidden in machine generated data to build new features, automate processes, and drive efficiency.
Store all your metrics in TimescaleDB. Always have the data you need to respond to service outages, conduct post-mortems, and plan for future capacity needs.
Understand your application activity over time to provide meaningful insights to your users.
Use built-in time-series functions to quickly store, visualize, and analyze pricing data. Combine pricing data with other indicators, all in the same database.
How are my temperature sensor readings changing over time?
SELECT time_bucket('10 seconds', time) AS ten_second,
  machine_id, avg(temperature) AS "avgT",
  min(temperature) AS "minT", max(temperature) AS "maxT",
  last(temperature, time) AS "lastT"
FROM measurements
WHERE machine_id = 'C931baF7'
  AND time > now() - interval '150s'
GROUP BY ten_second
ORDER BY ten_second DESC;
 ten_second | avgT | minT | maxT | lastT 
------------+------+------+------+-------
1499792590 | 52 | 50 | 54 | 52
1499792580 | 52 | 50 | 54 | 52
1499792570 | 51 | 50 | 54 | 51
1499792560 | 50 | 48 | 52 | 51
1499792550 | 50 | 48 | 51 | 50
1499792540 | 49 | 48 | 51 | 50
1499792530 | 50 | 47 | 52 | 50
1499792520 | 50 | 48 | 51 | 49
1499792510 | 51 | 48 | 53 | 50
1499792500 | 51 | 50 | 54 | 52
1499792490 | 52 | 50 | 53 | 51
1499792480 | 51 | 48 | 52 | 50
1499792470 | 52 | 49 | 53 | 52
1499792460 | 53 | 49 | 55 | 52
1499792450 | 53 | 50 | 55 | 53

IntegrationsEmbrace the PostgreSQL ecosystem

  • Visualization & reporting
  • Metrics & monitoring
  • Streaming & ingestion