initial import of thesis-dold

1 files changed, 12 insertions, 0 deletions

diff --git a/doc/system/plots/dbsize.sql b/doc/system/plots/dbsize.sql
new file mode 100644
index 000000000..4f4b23886
--- /dev/null
+++ b/doc/system/plots/dbsize.sql
@@ -0,0 +1,12 @@
+create temporary view sizes as
+  select table_name as n,
+         pg_relation_size(quote_ident(table_name)) / 1024.0 / 1024.0 as s_tbl,
+	 pg_indexes_size(quote_ident(table_name)) / 1024.0 / 1024.0 as s_idx
+   from information_schema.tables
+   where table_schema = 'public';
+
+
+select n, s_tbl, s_idx, s_tbl + s_idx from sizes where (s_tbl) != 0
+order by (s_tbl + s_idx);
+
+select sum(s_tbl), sum(s_idx), sum(s_tbl + s_idx) from sizes where s_tbl != 0;