SELECT metric, description, formatReadableSize(value) sizeFROM system.asynchronous_metricsWHERE metric LIKE '%Cach%' OR metric LIKE '%Mem%'ORDER BY value DESC;
現在のメモリ使用量別にテーブルを一覧表示
SELECT database, name, formatReadableSize(total_bytes)FROM system.tablesWHERE engine IN ('Memory','Set','Join');
マージで使用される合計メモリを出力する
SELECT formatReadableSize(sum(memory_usage)) FROM system.merges;
現在実行中のプロセスが使用している総メモリ量を出力
SELECT formatReadableSize(sum(memory_usage)) FROM system.processes;
辞書が使用する合計メモリを出力
SELECT formatReadableSize(sum(bytes_allocated)) FROM system.dictionaries;
主キーと索引の粒度が使用する合計メモリを出力する
SELECT sumIf(data_uncompressed_bytes, part_type = 'InMemory') AS memory_parts, formatReadableSize(sum(primary_key_bytes_in_memory)) AS primary_key_bytes_in_memory, formatReadableSize(sum(primary_key_bytes_in_memory_allocated)) AS primary_key_bytes_in_memory_allocated, formatReadableSize(sum(index_granularity_bytes_in_memory)) AS index_granularity_bytes_in_memory, formatReadableSize(sum(index_granularity_bytes_in_memory_allocated)) AS index_granularity_bytes_in_memory_allocatedFROM system.parts;