aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2002-06-12 23:41:50 +0000
committerBruce Momjian <bruce@momjian.us>2002-06-12 23:41:50 +0000
commit7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd (patch)
treeb4b8123cb29a84b9cd8f6c5f2be6eeb5711d3115
parente6e577490d1a94d134d7d83d21308f27a325bba3 (diff)
downloadpostgresql-7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd.tar.gz
postgresql-7e20a2e74fc9a4c75c0a3b3394f305ec954bb0dd.zip
Add mention of query showing pages used.
-rw-r--r--contrib/oid2name/README.oid2name4
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;
+
---------------------------------------------------------------------------