system trace_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 1048576 8192 524288 false true system query_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 262144 8192 131072 false system query_thread_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 262144 2048 131072 false system query_views_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 system part_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 262144 2048 131072 false system metric_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 262144 16384 131072 1000 false system asynchronous_metric_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7000 1048576 16384 524288 false system opentelemetry_span_log engine = MergeTree partition by toYYYYMMDD(finish_date) order by (finish_date, finish_time_us, trace_id) ttl finish_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 1048576 16384 524288 false system processors_profile_log toYYYYMMDD(event_date) event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE 7500 1048576 16384 524288 false