kn0wledge_libr@ry

User Tools

Site Tools

Trace:
free_space_on_sql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
free_space_on_sql [2021/06/22 08:19] – chifekfree_space_on_sql [2023/09/14 06:06] (current) – external edit 127.0.0.1
Line 4: Line 4:
 Запрос выведет размер всех таблиц в базе. Запрос выведет размер всех таблиц в базе.
  
-<CODE>+
   SELECT nspname || '.' || relname AS "relation",   SELECT nspname || '.' || relname AS "relation",
     pg_size_pretty(pg_relation_size(C.oid)) AS "size"     pg_size_pretty(pg_relation_size(C.oid)) AS "size"
Line 11: Line 11:
   WHERE nspname NOT IN ('pg_catalog', 'information_schema')   WHERE nspname NOT IN ('pg_catalog', 'information_schema')
   ORDER BY pg_relation_size(C.oid) DESC;   ORDER BY pg_relation_size(C.oid) DESC;
-</CODE>+
free_space_on_sql.1624349959.txt.gz · Last modified: 2023/09/14 06:06 (external edit)