From 9bba67aa9b57bb5a4198c413cd67fa340edcfec7 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Thu, 13 Jun 2002 00:21:52 +0000
Subject: [PATCH] Add script to show disk space per db.

---
 contrib/oid2name/README.oid2name | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

diff --git a/contrib/oid2name/README.oid2name b/contrib/oid2name/README.oid2name
index 7a0ff1d564..58ad43e947 100644
--- a/contrib/oid2name/README.oid2name
+++ b/contrib/oid2name/README.oid2name
@@ -84,6 +84,7 @@ Oid of table ips from database "test":
 ---------------------------------
 18737  = ips
 
+$ # show disk space for every db object
 $ du * | while read SIZE OID
 > do
 >	echo "$SIZE      `oid2name -q -d test -o $OID`"
@@ -92,6 +93,7 @@ $ du * | while read SIZE OID
 36      18722  = cities
 ...
 
+$ # same as above, but sort by largest first
 $ du * | while read SIZE OID
 > do
 >	echo "$SIZE      `oid2name -q -d test -o $OID`"
@@ -101,6 +103,18 @@ $ du * | while read SIZE OID
 1950    23903  = customers
 ...
 
+$ # show disk usage per database
+$ cd /u/pg/data/base
+$ du -s * | 
+> while read SIZE OID
+> do
+>	echo "$SIZE      `aspg oid2name -q | grep ^$OID' '`"
+> done |
+> sort -rn
+2256        18721  = test
+2135        18735  = postgres
+..
+
 This can be done in psql with:  (each page is typically 8k)
 
 test=> SELECT relpages, relfilenode, relname FROM pg_class ORDER BY relpages DESC;
@@ -112,4 +126,3 @@ Mail me with any problems or additions you would like to see.  Clearing
 house for the code will be at:  http://www.crimelabs.net
 
 b. palmer, bpalmer@crimelabs.net
-
-- 
2.40.0