Materialized hypertables

Continuous aggregates take raw data from the original hypertable, aggregate it, and store the aggregated data in a materialization hypertable. You can modify this materialized hypertable in the same way as any other hypertable.

Discover the name of a materialized hypertable

To change a materialized hypertable, you need to use its fully qualified name. To find the correct name, use the timescaledb_information.continuous_aggregates view. You can then use the name to modify it in the same way as any other hypertable.

1. Query the continuous_aggregates view

   SELECT view_name, format('%I.%I', materialization_hypertable_schema,
           materialization_hypertable_name) AS materialization_hypertable
       FROM timescaledb_information.continuous_aggregates;

2. Locate the hypertable name

   The results look like this:

            view_name         |            materialization_hypertable
   ---------------------------+---------------------------------------------------
   conditions_summary_hourly | _timescaledb_internal._materialized_hypertable_30
   conditions_summary_daily  | _timescaledb_internal._materialized_hypertable_31
   (2 rows)

Learn more

• Understand continuous aggregates: How continuous aggregates work, JOINs, and function support.
• Hierarchical continuous aggregates: Create continuous aggregates on top of other continuous aggregates.
• Convert continuous aggregates to the columnstore: Compress older aggregated data.
• Drop data from continuous aggregates: Remove materialized data.
• ALTER MATERIALIZED VIEW reference: Modify continuous aggregate settings.