<clickhouse>

    <trace_log>
        <database>system</database>
        <table>trace_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>1048576</max_size_rows>
        <reserved_size_rows>8192</reserved_size_rows>
        <buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
        <symbolize>true</symbolize>
    </trace_log>

    <query_log>
        <database>system</database>
        <table>query_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>262144</max_size_rows>
        <reserved_size_rows>8192</reserved_size_rows>
        <buffer_size_rows_flush_threshold>131072</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </query_log>

    <query_thread_log>
        <database>system</database>
        <table>query_thread_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>262144</max_size_rows>
        <reserved_size_rows>2048</reserved_size_rows>
        <buffer_size_rows_flush_threshold>131072</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </query_thread_log>

    <query_views_log>
        <database>system</database>
        <table>query_views_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
    </query_views_log>

    <part_log>
        <database>system</database>
        <table>part_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>262144</max_size_rows>
        <reserved_size_rows>2048</reserved_size_rows>
        <buffer_size_rows_flush_threshold>131072</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </part_log>

    <metric_log>
        <database>system</database>
        <table>metric_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>262144</max_size_rows>
        <reserved_size_rows>16384</reserved_size_rows>
        <buffer_size_rows_flush_threshold>131072</buffer_size_rows_flush_threshold>
        <collect_interval_milliseconds>1000</collect_interval_milliseconds>
        <flush_on_crash>false</flush_on_crash>
    </metric_log>

    <asynchronous_metric_log>
        <database>system</database>
        <table>asynchronous_metric_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7000</flush_interval_milliseconds>
        <max_size_rows>1048576</max_size_rows>
        <reserved_size_rows>16384</reserved_size_rows>
        <buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </asynchronous_metric_log>

    <opentelemetry_span_log>
        <database>system</database>
        <table>opentelemetry_span_log</table>
        <engine>
            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
        </engine>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>1048576</max_size_rows>
        <reserved_size_rows>16384</reserved_size_rows>
        <buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </opentelemetry_span_log>

    <processors_profile_log>
        <database>system</database>
        <table>processors_profile_log</table>
        <partition_by>toYYYYMMDD(event_date)</partition_by>
        <ttl>event_date + INTERVAL ${CLICKHOUSE_LOGS_RETENTION_DAYS} DAY DELETE</ttl>

        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <max_size_rows>1048576</max_size_rows>
        <reserved_size_rows>16384</reserved_size_rows>
        <buffer_size_rows_flush_threshold>524288</buffer_size_rows_flush_threshold>
        <flush_on_crash>false</flush_on_crash>
    </processors_profile_log>

</clickhouse>