personal_infra/clickhouse_maintenance.md


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

```
$ ssh clickhouse...
$ clickhouse-client
$ use system;
$ SELECT
    table,
    formatReadableSize(sum(bytes)) AS size,
    min(min_date) AS min_date,
    max(max_date) AS max_date
FROM system.parts
WHERE active
GROUP BY table
ORDER BY sum(bytes) ASC
$ truncate table ...
```