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::