author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Tue, 08 Jun 2021 16:50:18 +0300 (2021-06-08) | |
changeset 2509 | 6a1fb2d1bee7 |
parent 2508 | fe9788ce44ba |
child 2510 | cdc491306fef |
postgres.rst | file | annotate | diff | comparison | revisions |
--- 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::