Largest tables with TOAST.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 10 Jan 2019 11:43:56 +0200
changeset 2339 cb96d35c46cf
parent 2338 4837614fea35
child 2340 fc5d1153f3df
Largest tables with TOAST.
postgres.rst
--- a/postgres.rst	Wed Jan 09 19:32:16 2019 +0200
+++ b/postgres.rst	Thu Jan 10 11:43:56 2019 +0200
@@ -280,6 +280,14 @@
 Largest table in the PostgreSQL database::
 
   SELECT relname, relpages FROM pg_class ORDER BY relpages DESC;
+  SELECT relname, pg_size_pretty(pg_relation_size(p.oid)) FROM pg_class ORDER BY relpages DESC;
+
+Largest tables with TOAST::
+
+  SELECT p.relname, t.relname, pg_size_pretty(pg_relation_size(p.oid)), p.relpages
+  FROM pg_class p
+  LEFT JOIN pg_class t ON t.reltoastrelid = p.oid
+  ORDER BY p.relpages DESC;
 
 MVCC and transaction id
 =======================