Added ordering when display table sizes.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 08 Jun 2021 16:50:18 +0300
changeset 2509 6a1fb2d1bee7
parent 2508 fe9788ce44ba
child 2510 cdc491306fef
Added ordering when display table sizes.
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::