# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1623160218 -10800
# Node ID 6a1fb2d1bee7267378255ec8fccd41c1d8b1d358
# Parent  fe9788ce44baa52d7f634b9b3fd3ce70e5891664
Added ordering when display table sizes.

diff -r fe9788ce44ba -r 6a1fb2d1bee7 postgres.rst
--- 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::