job_id | application_name | schedule_interval | max_runtime | max_retries | retry_period | proc_schema | proc_name | owner | scheduled | fixed_schedule | config | next_start | initial_start | hypertable_schema | hypertable_name | check_schema | check_name --------+---------------------------+-------------------+-------------+-------------+--------------+------------------------+--------------------+--------+-----------+----------------+--------------------------------------------------------------+-------------------------------+---------------+-------------------+-----------------+------------------------+-------------------------- 1000 | Compression Policy [1000] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 1, "compress_after": 612000} | -infinity | | public | history | _timescaledb_functions | policy_compression_check 1001 | Compression Policy [1001] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 2, "compress_after": 612000} | -infinity | | public | history_uint | _timescaledb_functions | policy_compression_check 1004 | Compression Policy [1004] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 3, "compress_after": 612000} | 2025-07-15 15:49:26.97526+03 | | public | history_log | _timescaledb_functions | policy_compression_check 1003 | Compression Policy [1003] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 4, "compress_after": 612000} | 2025-07-15 15:49:28.01218+03 | | public | history_text | _timescaledb_functions | policy_compression_check 1002 | Compression Policy [1002] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 5, "compress_after": 612000} | 2025-07-15 15:49:28.509636+03 | | public | history_str | _timescaledb_functions | policy_compression_check 1005 | Compression Policy [1005] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 6, "compress_after": 612000} | 2025-07-15 15:49:27.36708+03 | | public | history_bin | _timescaledb_functions | policy_compression_check 1008 | Compression Policy [1008] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 7, "compress_created_before": "170:00:00"} | 2025-07-15 15:50:06.319478+03 | | public | auditlog | _timescaledb_functions | policy_compression_check 1006 | Compression Policy [1006] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 8, "compress_after": 612000} | 2025-07-15 15:49:26.896061+03 | | public | trends | _timescaledb_functions | policy_compression_check 1007 | Compression Policy [1007] | 1 day | 00:00:00 | -1 | 01:00:00 | _timescaledb_functions | policy_compression | zabbix | t | f | {"hypertable_id": 9, "compress_after": 612000} | 2025-07-15 15:49:27.023209+03 | | public | trends_uint | _timescaledb_functions | policy_compression_check (9 строк)