Untitled

 avatar
unknown
plain_text
a year ago
277 B
5
Indexable
CREATE TABLE data_time (
    device_uuid uuid NOT NULL,
    generated_time TIMESTAMPTZ NOT NULL,
    normal_usage DOUBLE PRECISION NULL
);

SELECT create_hypertable('data_time', by_range('generated_time'));

CREATE INDEX id_time ON data_time (device_uuid, generated_time DESC);
Editor is loading...
Leave a Comment