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

3 votes424 views2 answers
See mysql users ubuntu
SQL
2 votes377 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote347 views1 answer
Oracle create table auto generated primary key
SQL
2 votes376 views1 answer
How to delete columns in sql
SQL
-1 vote363 views1 answer
Sql oracle take only last results
SQL
0 vote293 views1 answer
<script>alert
SQL
0 vote331 views1 answer
Postgresql parse json array
SQL
0 vote365 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote362 views1 answer
Postgresql combine values in one field
SQL
0 vote371 views1 answer
Proc sql not in working
SQL