How to get all table size usage in Postgres

From time to time you might see strange disk usage on your database server. This query is a quick way to see if any of the tables are growing inexpectedly.

select
  table_name,
  pg_size_pretty(pg_relation_size(quote_ident(table_name))),
  pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 3 desc;