Untitled
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