Largest tables with TOAST.
--- 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
=======================