diff -r 6a1fb2d1bee7 -r cdc491306fef postgres.rst --- a/postgres.rst Tue Jun 08 16:50:18 2021 +0300 +++ b/postgres.rst Tue Jun 08 17:06:25 2021 +0300 @@ -449,7 +449,7 @@ SELECT pg_table_size('schemaname.tablename'); -Sole table size (without indexes and other):: +Sole table size (without indexes and TOAST):: SELECT pg_size_pretty(pg_relation_size('schemaname.tablename')); @@ -460,6 +460,10 @@ 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; + SELECT pg_table_size(t.schemaname ||'.'|| t.tablename), pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* + FROM pg_tables t + ORDER BY 1 DESC; + Largest tables with TOAST:: SELECT p.relname, t.relname, pg_size_pretty(pg_relation_size(p.oid)), p.relpages