timescaledb_information.continuous_aggregates

Get metadata and settings information for continuous aggregates.

Available columns

Name Type Description
hypertable_schema TEXT Schema of the hypertable from the continuous aggregate view
hypertable_name TEXT Name of the hypertable from the continuous aggregate view
view_schema TEXT Schema for continuous aggregate view
view_name TEXT User supplied name for continuous aggregate view
view_owner TEXT Owner of the continuous aggregate view
materialized_only BOOLEAN Return only materialized data when querying the continuous aggregate view
compression_enabled BOOLEAN Is compression enabled for the continuous aggregate view?
materialization_hypertable_schema TEXT Schema of the underlying materialization table
materialization_hypertable_name TEXT Name of the underlying materialization table
view_definition TEXT SELECT query for continuous aggregate view
finalized BOOLEAN Whether 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