diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-06-13 00:21:52 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-06-13 00:21:52 +0000 |
| commit | 9bba67aa9b57bb5a4198c413cd67fa340edcfec7 (patch) | |
| tree | c15ee3c79b7fc592fbc398b01d9a4179372c611f | |
| parent | 4f8795eb71160cbf633602f0fc297cd3a29bf172 (diff) | |
| download | postgresql-9bba67aa9b57bb5a4198c413cd67fa340edcfec7.tar.gz postgresql-9bba67aa9b57bb5a4198c413cd67fa340edcfec7.zip | |
Add script to show disk space per db.
| -rw-r--r-- | contrib/oid2name/README.oid2name | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/contrib/oid2name/README.oid2name b/contrib/oid2name/README.oid2name index 7a0ff1d5640..58ad43e947f 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 - |