From 6cc9d8c72a56563b6d1a12b8b441dfa9dde345e9 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Tue, 28 Apr 2020 17:29:52 +0200
Subject: Long overdue first commit with content

---
 .../en/blog/miscellaneous/debug-disk-usage-postgresql.md   | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 content/en/blog/miscellaneous/debug-disk-usage-postgresql.md

(limited to 'content/en/blog/miscellaneous/debug-disk-usage-postgresql.md')

diff --git a/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md b/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md
new file mode 100644
index 0000000..827d69f
--- /dev/null
+++ b/content/en/blog/miscellaneous/debug-disk-usage-postgresql.md
@@ -0,0 +1,14 @@
+---
+title: "Investigate postgresql disk usage"
+linkTitle: "Investigate postgresql disk usage"
+date: 2015-11-24
+description: >
+  Investigate postgresql disk usage
+---
+
+## How to debug disk occupation in postgresql
+
+- get a database oid number from `ncdu` in `/var/lib/postgresql`
+- reconcile oid number and db name with : `select oid,datname from pg_database where oid=18595;`
+- Then in database : `select table_name,pg_relation_size(quote_ident(table_name)) from information_schema.tables where table_schema = 'public' order by 2;`
+
-- 
cgit v1.2.3