timescaledb_information.continuous_aggregates

Get metadata and settings information for continuous aggregates.

Available Columns

NameDescription
hypertable_schema(NAME) Schema of the hypertable from the continuous aggregate view
hypertable_name(NAME) Name of the hypertable from the continuous aggregate view
view_schema(NAME) Schema for continuous aggregate view
view_name(NAME) User supplied name for continuous aggregate view
view_owner(NAME) Owner of the continuous aggregate view
materialized_only(BOOLEAN) Return only materialized data when querying the continuous aggregate view.
materialization_hypertable_schema(NAME) Schema of the underlying materialization table
materialization_hypertable_name(NAME) Name of the underlying materialization table
view_definition(TEXT) SELECT query for continuous aggregate view

Sample Usage

  1. SELECT * FROM timescaledb_information.continuous_aggregates;
  3. -[ RECORD 1 ]---------------------+-------------------------------------------------
  4. hypertable_schema                 | public
  5. hypertable_name                   | foo
  6. view_schema                       | public 
  7. view_name                         | contagg_view
  8. view_owner                        | postgres
  9. materialized_only                 | f
  10. materialization_hypertable_schema | _timescaledb_internal
  11. materialization_hypertable_name   | _materialized_hypertable_2
  12. view_definition                   |  SELECT foo.a,                                  +
  13.                                   |     COUNT(foo.b) AS countb                      +
  14.                                   |    FROM foo                                     +
  15.                                   |   GROUP BY (time_bucket('1 day', foo.a)), foo.a;