diff options
author | Bruce Momjian <bruce@momjian.us> | 2002-06-12 23:41:50 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2002-06-12 23:41:50 +0000 |
commit | 7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd (patch) | |
tree | b4b8123cb29a84b9cd8f6c5f2be6eeb5711d3115 | |
parent | e6e577490d1a94d134d7d83d21308f27a325bba3 (diff) | |
download | postgresql-7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd.tar.gz postgresql-7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd.zip |
Add mention of query showing pages used.
-rw-r--r-- | contrib/oid2name/README.oid2name | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/contrib/oid2name/README.oid2name b/contrib/oid2name/README.oid2name index 51eb5277f51..53d88e23b44 100644 --- a/contrib/oid2name/README.oid2name +++ b/contrib/oid2name/README.oid2name @@ -101,6 +101,10 @@ $ du * | while read SIZE OID 1950 23903 = customers ... +This can be done in psql with: (each page is typically 8k) + +test=> SELECT relpages, relname FROM pg_class ORDER BY relpages DESC; + --------------------------------------------------------------------------- |