---
title: show_policies() | Tiger Data Docs
description: Show all policies that are currently set on a continuous aggregate
---

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

Show all policies that are currently set on a continuous aggregate.

```
timescaledb_experimental.show_policies(
     relation REGCLASS
) RETURNS SETOF JSONB
```

## Samples

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:

Terminal window

```
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"}
```

## Arguments

The syntax is:

```
SELECT * FROM show_policies(
    relation = '<view_name>'
);
```

| Name       | Type       | Default | Required | Description                                      |
| ---------- | ---------- | ------- | -------- | ------------------------------------------------ |
| `relation` | `REGCLASS` | -       | ✔        | The continuous aggregate to display policies for |

## Returns

| Column          | Type    | Description                                             |
| --------------- | ------- | ------------------------------------------------------- |
| `show_policies` | `JSONB` | Details for each policy set on the continuous aggregate |