show_policies()
CommunityCommunity functions are available under Timescale Community Edition. Click to learn more.ExperimentalExperimental features are not suitable for production environments. They are included under the TimescaleDB experimental schema. Click to learn more.Show all policies that are currently set on a continuous aggregate.
timescaledb_experimental.show_policies(relation REGCLASS) RETURNS SETOF JSONB
Warning
Experimental features could have bugs. They might not be backwards compatible, and could be removed in future releases. Use these features at your own risk, and do not use any experimental features in production.
| Name | Type | Description |
|---|---|---|
relation | REGCLASS | The continuous aggregate to display policies for |
| Column | Type | Description |
|---|---|---|
show_policies | JSONB | Details for each policy set on the continuous aggregate |
Given a continuous aggregate named example_continuous_aggregate, show all the
policies set on it:
SELECT timescaledb_experimental.show_policies('example_continuous_aggregate');
Example of returned data:
show_policies--------------------------------------------------------------------------------{"policy_name": "policy_compression", "compress_after": 11, "compress_interval": "@ 1 day"}{"policy_name": "policy_refresh_continuous_aggregate", "refresh_interval": "@ 1 hour", "refresh_end_offset": 1, "refresh_start_offset": 10}{"drop_after": 20, "policy_name": "policy_retention", "retention_interval": "@ 1 day"}
Keywords
Found an issue on this page?Report an issue or Edit this page in GitHub.