List PostgreSQL database tables by size and rows

postgresql-table-size-rows.sql

SELECT
    "s"."relname" AS "table_name",
    pg_total_relation_size("s"."schemaname" || '.' || "s"."relname") / 1024 / 1024 AS "total_size",
    pg_relation_size("s"."schemaname" || '.' || "s"."relname") / 1024 / 1024 AS "table_size",
    (pg_total_relation_size("s"."schemaname" || '.' || "s"."relname") - pg_relation_size("s"."schemaname" || '.' || "s"."relname")) / 1024 / 1024 AS "index_size",
    "s"."n_live_tup" AS "table_rows"
FROM
    "pg_stat_user_tables" "s"
JOIN
    "pg_class" "c" ON "s"."relid" = "c"."oid"
ORDER BY
    pg_total_relation_size("s"."schemaname" || '.' || "s"."relname") DESC;