集群表分区最大的active parts数

SELECT percentage FROM (
    WITH version_data AS (
    SELECT
        CASE
            WHEN toFloat64(substr(version(), 1, 4)) > 23.6 THEN 3000
            ELSE 300
        END AS default_value
    ),
    settings_count AS (
        SELECT
            count(*) AS count,sum(toUInt16(value)) as value
        FROM system.settings
        WHERE name = 'parts_to_throw_insert' and changed=1 
    ),
    max_parts_per_partition AS (
        SELECT max(part_count) AS max_parts
        FROM
        (
            SELECT
                database,
                table,
                partition,
                count() AS part_count
            FROM system.parts
            WHERE active
            GROUP BY
                database,
                table,
                partition
        ) AS partitions
    )
    SELECT ROUND(max_parts / CASE WHEN settings_count.count = 0 THEN toUInt16(version_data.default_value) ELSE toUInt16(settings_count.value)  END, 4) AS percentage
    FROM max_parts_per_partition, version_data, settings_count)
    LIMIT 1