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.compression_table
The compression_table view in the timeseries_views schema allows users to the compression ratio of all time-series tables. after_compression_size and compression_ratio cannot be null only when there is at least one compressed chunk group in a time-series table. If at least one chunk group is compressed in a time-series table, the value of after_compression_size is the value of before_compression_size for the uncompressed chunk groups plus the value of after_compression_size for the compressed chunk groups.
Table 1 compression_table columns
| Field | Type | Description |
|---|---|---|
| schemaname | name | Name of a schema to which a time-series table belongs. |
| tablename | name | Name of a time-series table. |
| before_compression_size | bigint | Size (in KB) of a time-series table before it is compressed. |
| after_compression_size | bigint | Size (in KB) of a time-series table after it is compressed. |
| compression_ratio | float | Compression ratio of a time-series table (rounded up to 2 decimal places). |