TimescaleDB API Reference

Overview

CREATE TABLE

create_hypertable()

show_chunks()

drop_chunks()

reorder_chunk()

split_chunk()

merge_chunks()

move_chunk()

detach_chunk()

attach_chunk()

add_reorder_policy()

remove_reorder_policy()

attach_tablespace()

detach_tablespace()

detach_tablespaces()

show_tablespaces()

set_chunk_time_interval()

set_integer_now_func()

add_dimension()

enable_chunk_skipping()

disable_chunk_skipping()

CREATE INDEX (Transaction Per Chunk)

hypertable_size()

hypertable_approximate_size()

hypertable_detailed_size()

hypertable_approximate_detailed_size()

hypertable_index_size()

chunks_detailed_size()

Overview

ALTER TABLE (hypercore)

add_columnstore_policy()

remove_columnstore_policy()

convert_to_columnstore()

convert_to_rowstore()

timescaledb_information.hypertable_columnstore_settings

hypertable_columnstore_stats()

timescaledb_information.chunk_columnstore_settings

chunk_columnstore_stats()

Overview

CREATE MATERIALIZED VIEW

ALTER MATERIALIZED VIEW

DROP MATERIALIZED VIEW

refresh_continuous_aggregate()

add_continuous_aggregate_policy()

add_policies()

alter_policies()

show_policies()

remove_continuous_aggregate_policy()

cagg_migrate()

remove_policies()

remove_all_policies()

Overview

add_retention_policy()

remove_retention_policy()

Overview

add_job()

alter_job()

delete_job()

run_job()

Overview

generate_uuidv7()

to_uuidv7()

to_uuidv7_boundary()

uuid_timestamp()

uuid_timestamp_micros()

uuid_version()

Overview

Overview

timescaledb_information.chunks

timescaledb_information.chunk_compression_settings

timescaledb_information.continuous_aggregates

timescaledb_information.compression_settings

timescaledb_information.data_nodes

timescaledb_information.dimensions

timescaledb_information.hypertables

timescaledb_information.hypertable_compression_settings

timescaledb_information.jobs

timescaledb_information.job_stats

timescaledb_information.job_errors

timescaledb_information.job_history

timescaledb_experimental.policies

Overview

TimescaleDB configuration and tuning

Grand Unified Configuration (GUC) parameters

Overview

get_telemetry_report()

timescaledb_post_restore()

timescaledb_pre_restore()

API reference tag overview

Overview

ALTER TABLE (Compression)

add_compression_policy()

remove_compression_policy()

compress_chunk()

decompress_chunk()

recompress_chunk()

hypertable_compression_stats()

chunk_compression_stats()