---
title: timescaledb_experimental.policies | Tiger Data Docs
description: Get information about all policies set on continuous aggregates
---

Early access [2.10.0](https://github.com/timescale/timescaledb/releases/tag/2.10.0)

The `policies` view provides information on all policies set on continuous aggregates.

Only policies applying to continuous aggregates are shown in this view. Policies applying to regular hypertables or regular materialized views are not displayed.

## Samples

Select from the `timescaledb_experimental.policies` table to view it:

```
SELECT * FROM timescaledb_experimental.policies;
```

Example of the returned output:

```
-[ RECORD 1 ]--------------------------------------------------------------------
relation_name     | mat_m1
relation_schema   | public
schedule_interval | @ 1 hour
proc_schema       | _timescaledb_internal
proc_name         | policy_refresh_continuous_aggregate
config            | {"end_offset": 1, "start_offset", 10, "mat_hypertable_id": 2}
hypertable_schema | _timescaledb_internal
hypertable_name   | _materialized_hypertable_2
-[ RECORD 2 ]--------------------------------------------------------------------
relation_name     | mat_m1
relation_schema   | public
schedule_interval | @ 1 day
proc_schema       | _timescaledb_internal
proc_name         | policy_compression
config            | {"hypertable_id": 2, "compress_after", 11}
hypertable_schema | _timescaledb_internal
hypertable_name   | _materialized_hypertable_2
-[ RECORD 3 ]--------------------------------------------------------------------
relation_name     | mat_m1
relation_schema   | public
schedule_interval | @ 1 day
proc_schema       | _timescaledb_internal
proc_name         | policy_retention
config            | {"drop_after": 20, "hypertable_id": 2}
hypertable_schema | _timescaledb_internal
hypertable_name   | _materialized_hypertable_2
```

## Returns

| Column              | Type     | Description                                                                              |
| ------------------- | -------- | ---------------------------------------------------------------------------------------- |
| `relation_name`     | TEXT     | Name of the continuous aggregate                                                         |
| `relation_schema`   | TEXT     | Schema of the continuous aggregate                                                       |
| `schedule_interval` | INTERVAL | How often the policy job runs                                                            |
| `proc_schema`       | TEXT     | Schema of the policy job                                                                 |
| `proc_name`         | TEXT     | Name of the policy job                                                                   |
| `config`            | JSONB    | Configuration details for the policy job                                                 |
| `hypertable_schema` | TEXT     | Schema of the hypertable that contains the actual data for the continuous aggregate view |
| `hypertable_name`   | TEXT     | Name of the hypertable that contains the actual data for the continuous aggregate view   |