postgres.rst
changeset 2509 6a1fb2d1bee7
parent 2507 8e8c8adde585
child 2510 cdc491306fef
--- a/postgres.rst	Wed Jun 02 16:39:36 2021 +0300
+++ b/postgres.rst	Tue Jun 08 16:50:18 2021 +0300
@@ -453,7 +453,7 @@
 
   SELECT pg_size_pretty(pg_relation_size('schemaname.tablename'));
 
-  SELECT pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* FROM pg_tables t;
+  SELECT pg_relation_size(t.schemaname ||'.'|| t.tablename), t.* FROM pg_tables t ORDER BY 1 DESC;
 
 Largest table in the PostgreSQL database::