Differences

This shows you the differences between two versions of the page.

--- free_space_on_sql [2021/06/22 07:33] – создано chifek
+++ free_space_on_sql [2023/09/14 06:06] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 Запрос выведет размер всех таблиц в базе.
-''SELECT nspname || '.' || relname AS "relation",
+  SELECT nspname || '.' || relname AS "relation",
     pg_size_pretty(pg_relation_size(C.oid)) AS "size"
   FROM pg_class C
   LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
   WHERE nspname NOT IN ('pg_catalog', 'information_schema')
-  ORDER BY pg_relation_size(C.oid) DESC;''
+  ORDER BY pg_relation_size(C.oid) DESC;