timescaledb_information.continuous_aggregates

Get metadata and settings information for continuous aggregates.

Available columns

NameTypeDescription
hypertable_schemaTEXTSchema of the hypertable from the continuous aggregate view
hypertable_nameTEXTName of the hypertable from the continuous aggregate view
view_schemaTEXTSchema for continuous aggregate view
view_nameTEXTUser supplied name for continuous aggregate view
view_ownerTEXTOwner of the continuous aggregate view
materialized_onlyBOOLEANReturn only materialized data when querying the continuous aggregate view
compression_enabledBOOLEANIs compression enabled for the continuous aggregate view?
materialization_hypertable_schemaTEXTSchema of the underlying materialization table
materialization_hypertable_nameTEXTName of the underlying materialization table
view_definitionTEXTSELECT query for continuous aggregate view
finalizedBOOLEANWhether the continuous aggregate stores data in finalized or partial form. Since TimescaleDB 2.7, the default is finalized.

Sample usage

  2. SELECT * FROM timescaledb_information.continuous_aggregates;
  4. -[ RECORD 1 ]---------------------+-------------------------------------------------
  6. hypertable_schema                 | public
  8. hypertable_name                   | foo
  10. view_schema                       | public 
  13. view_name                         | contagg_view
  15. view_owner                        | postgres
  17. materialized_only                 | f
  19. compression_enabled               | f
  21. materialization_hypertable_schema | _timescaledb_internal
  23. materialization_hypertable_name   | _materialized_hypertable_2
  25. view_definition                   |  SELECT foo.a,                                  +
  27.                                   |     COUNT(foo.b) AS countb                      +
  29.                                   |    FROM foo                                     +
  31.                                   |   GROUP BY (time_bucket('1 day', foo.a)), foo.a;
  33. finalized                         | t