> ## Documentation Index
> Fetch the complete documentation index at: https://mintlify-poc.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# timescaledb_information.continuous_aggregates

> Get metadata and settings information for continuous aggregates

export const TIMESCALE_DB = 'TimescaleDB';

export const HYPERTABLE = 'hypertable';

export const CAGG = 'continuous aggregate';

<Icon icon="tag" iconType="duotone" /> Since [1.3.0][tsdb-1.3.0]

Get metadata and settings information for {CAGG}s.

## Samples

```sql theme={"dark"}
SELECT * FROM timescaledb_information.continuous_aggregates;

-[ RECORD 1 ]---------------------+-------------------------------------------------
hypertable_schema                 | public
hypertable_name                   | foo
view_schema                       | public
view_name                         | contagg_view
view_owner                        | postgres
materialized_only                 | f
compression_enabled               | f
materialization_hypertable_schema | _timescaledb_internal
materialization_hypertable_name   | _materialized_hypertable_2
view_definition                   |  SELECT foo.a,                                  +
                                  |     COUNT(foo.b) AS countb                      +
                                  |    FROM foo                                     +
                                  |   GROUP BY (time_bucket('1 day', foo.a)), foo.a;

```

## Returns

| Name                                | Type    | Description                                                 |
| ----------------------------------- | ------- | ----------------------------------------------------------- |
| `hypertable_schema`                 | TEXT    | Schema of the {HYPERTABLE} from the {CAGG} view             |
| `hypertable_name`                   | TEXT    | Name of the {HYPERTABLE} from the {CAGG} view               |
| `view_schema`                       | TEXT    | Schema for {CAGG} view                                      |
| `view_name`                         | TEXT    | User supplied name for {CAGG} view                          |
| `view_owner`                        | TEXT    | Owner of the {CAGG} view                                    |
| `materialized_only`                 | BOOLEAN | Return only materialized data when querying the {CAGG} view |
| `compression_enabled`               | BOOLEAN | Is compression enabled for the {CAGG} 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 {CAGG} view                              |

[tsdb-1.3.0]: https://github.com/timescale/timescaledb/releases/tag/1.3.0