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

10 votes341 views2 answers
Sql pagination offset
SQL
0 vote329 views1 answer
Formatting code with SQL Developer
SQL
9 votes332 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote346 views1 answer
Update sql sintax
SQL
0 vote317 views1 answer
Mysql jdbc timezone
SQL
2 votes346 views3 answers
Sql truncate table
SQL
0 vote321 views1 answer
Describe in sqlite3
SQL
0 vote310 views1 answer
Find number of entries sql
SQL
0 vote324 views2 answers
Azure sql-datenbank
SQL
-1 vote333 views2 answers
Sql convert date to string yyyy-mm-dd
SQL