Early access
The policies view provides information on all policies set on s.
Only policies applying to s are shown in this view. Policies
applying to regular s or regular materialized views are not displayed.
Samples
Select from the timescaledb_experimental.policies table to view it:
SELECT * FROM timescaledb_experimental.policies;
-[ 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
Available columns
| Column | Type | Description |
|---|
relation_name | TEXT | Name of the |
relation_schema | TEXT | Schema of the |
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 that contains the actual data for the view |
hypertable_name | TEXT | Name of the that contains the actual data for the view |
