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 votes339 views1 answer
Sql alchemy or
SQL
0 vote363 views1 answer
R write csv without index
SQL
-1 vote377 views5 answers
Convert sql to linq query online
SQL
0 vote421 views1 answer
Hierarchal database table
SQL
0 vote329 views1 answer
Deny select insert update delete sql
SQL
12 votes351 views2 answers
Delete all entries postgres
SQL
1 vote365 views1 answer
Postgresql escape single quote
SQL
0 vote339 views2 answers
Mysql select date from datetime
SQL
0 vote495 views1 answer
Sql insert exemplo
SQL
0 vote358 views3 answers
Sql query checker
SQL