TimescaleDB 2.14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version() "Postgres Version", installed_version "TimescaleDB Version"
from pg_available_extensions
where name = 'timescaledb';

Postgres Version
TimescaleDB Version

PostgreSQL 16.14 (Debian 16.14-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2.14.2

SELECT 1

-- 2.14 generalised hypertable dimensions: by_range() replaces the
-- positional arguments create_hypertable() used to take
create table reading (t timestamptz not null, v double precision);
select create_hypertable('reading', by_range('t'));

CREATE TABLE

create_hypertable

(1,t)

SELECT 1

insert into reading
select '2026-01-01'::timestamptz + (n || ' hour')::interval, n
from generate_series(1,48) n;

INSERT 0 48

select time_bucket('1 day', t) as day, count(*) as readings
from reading group by 1 order by 1;

day
readings

2026-01-01 00:00:00+00
23

2026-01-02 00:00:00+00
24

2026-01-03 00:00:00+00
1

SELECT 3

day	readings
2026-01-01 00:00:00+00	23
2026-01-02 00:00:00+00	24
2026-01-03 00:00:00+00	1