From 71cc54e1abe890f8b57886d84dcc03f30289e53b Mon Sep 17 00:00:00 2001
From: alex <alex@pdp7.net>
Date: Tue, 23 Jan 2024 22:38:36 +0100
Subject: [PATCH] Add clickhouse_maintenance

---
 personal_infra/clickhouse_maintenance.md | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 personal_infra/clickhouse_maintenance.md

diff --git a/personal_infra/clickhouse_maintenance.md b/personal_infra/clickhouse_maintenance.md
new file mode 100644
index 0000000..e8d3e71
--- /dev/null
+++ b/personal_infra/clickhouse_maintenance.md
@@ -0,0 +1,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 ...
+```
-- 
2.47.3