v2.0
- About Uqbar
- Release Note
- Uqbar Installation
- Uqbar Management
- Data Retention Policy
- Time-Series Table Management
- Time-Series Data Write
- Data Compression
- Data Deletion
- Data Query
- Continuous Aggregation
- Time-Series Views
- Cluster Management
- Backup and Restoration
- Security
- GUC Parameters
- SQL Syntax
- Third Party Tools Support
- Glossary
timeseries_views.continuous_aggregation
timeseries_views.continuous_aggregation view provides continuous aggregation information.
Table 1 timeseries_views.continuous_aggregation view fields
| name | type | description |
|---|---|---|
| schema | name | The schema to which the continuous aggregation belongs |
| caname | name | Name of the continuous aggregation |
| resample_interval | text | Auto-resampling interval of continuous aggregation |
| job_id | bigint | job_id for background task of continuous aggregation |
| status | name | The current task status of background task of continuous aggregation (running, finished, failed, disable) |
| last_run_date | timestamp without time zone | Last execution time of background task of continuous aggregation |
| next_run_date | timestamp without time zone | Next execution time of background task of continuous aggregation |
| query | text | query statement used for continuous aggregation sampling |
| failure_count | smallint | Failure count, continuous aggregation tasks are no longer executed after 16 consecutive failures |
| failure_msg | text | The latest failure information of background task of continuous aggregation, if there is no failure information, it is empty |