Postgresql check total storage

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
  LIMIT 20;

Source: wiki.postgresql.org

Similar codes

2 votes108 views2 answers
Sql lag
SQL
22 votes101 views3 answers
Join three tables sql
SQL
0 vote103 views1 answer
SQL Query to delete all the tables in a database
SQL
28 votes104 views4 answers
Delete database mysql
SQL
0 vote97 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote97 views1 answer
Sql where last 12 months
SQL
0 vote59 views1 answer
Copy data from cell to cell mysql
SQL
0 vote107 views1 answer
Mariadb search columns
SQL
0 vote61 views1 answer
Sql truncate table referencing itself
SQL
0 vote108 views1 answer
Add alternate add column sql
SQL