# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1547113436 -7200
# Node ID cb96d35c46cf964a18d21350c26827d4b2ab9634
# Parent  4837614fea355e59cb9d6c60959c22aa6f656c6d
Largest tables with TOAST.

diff -r 4837614fea35 -r cb96d35c46cf 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
 =======================