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

0 vote151 views1 answer
Sql quary stuf
SQL
1 vote133 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
10 votes97 views2 answers
Sql where clause multiple values
SQL
5 votes153 views3 answers
Show indexes mysql
SQL
16 votes122 views1 answer
Mysql mediumint max value
SQL
0 vote132 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote196 views1 answer
Alter table name including schema
SQL
1 vote120 views1 answer
Oracle explain plan
SQL
0 vote125 views1 answer
Run postgresql dump to csv
SQL
0 vote127 views1 answer
Mysql timediff
SQL