# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1623161185 -10800
# Node ID cdc491306fef9a66d6d33f55f17f46481893ace7
# Parent  6a1fb2d1bee7267378255ec8fccd41c1d8b1d358
About pg_relation_size.

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