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 votes162 views2 answers
Reset mysql root password mac
SQL
0 vote144 views1 answer
Google cloud sql postgres url example
SQL
42 votes201 views6 answers
Sql query duplicate rows
SQL
1 vote118 views1 answer
How to delete data from sql database in android
SQL
0 vote133 views1 answer
Select from 3 tables one is empty
SQL
1 vote83 views1 answer
Full text index mysql
SQL
0 vote124 views1 answer
Check if table exists oracle
SQL
0 vote228 views2 answers
Execute stored procedure without db set
SQL
2 votes128 views2 answers
Join update query in sql
SQL
0 vote123 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL