CH?
SELECT name, formatReadableSize(sum(data_compressed_bytes)) AS compressed, formatReadableSize(sum(data_uncompressed_bytes)) AS uncompressed, (sum(data_compressed_bytes) * 100) / sum(data_uncompressed_bytes) AS compress_ratio FROM system.columns WHERE (table = 'graphite') AND (name IN ('Path', 'Value', 'Date', 'Time')) GROUP BY name ORDER BY sum(data_compressed_bytes) ASC Так?
Обсуждают сегодня