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

6 votes149 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote248 views1 answer
Sql ssrs
SQL
0 vote197 views1 answer
What is mysql_pconnect
SQL
5 votes197 views4 answers
Select random rows sql
SQL
0 vote210 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote185 views1 answer
Sql join on a subquery
SQL
0 vote257 views1 answer
Merge clause with inner join
SQL
0 vote211 views1 answer
How to map sql column to custom names
SQL
49 votes298 views6 answers
Mysql add column to table
SQL
0 vote239 views1 answer
Sql from null to not null
SQL