# relpages is the number of 8 Kilobyte pages used by each table.
SELECT relname, relpages FROM pg_class ORDER BY 2 DESC;