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.
Rich time-series analytics
Built-in tools to perform common time-series data analysis, including buckets, gap filling, aggregations, and more.
Convenience of SQL
Get started right away using the query language your developers and business analysts already know.
Massive scale and performance
Write millions of data points per second. Store 100s of billions of rows and 10s of terabytes of data.
Powered by PostgreSQL
Leverage the reliability, maturity, and operational efficiency of one of the world's most popular databases.
What is time-series data?
Learn more about what time-series
data is and why it matters.
Why TimescaleDB?
Get a better understanding of how
TimescaleDB works.
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;
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
