Table Sizes

select schemaname, tablename,
       pg_size_pretty(pg_total_relation_size(schemaname || '.' || tablename)) as size
from pg_tables
where schemaname = 'ores'
order by pg_total_relation_size(schemaname || '.' || tablename) desc;

| schemaname | tablename        | size    |
|------------+------------------+---------|
| ores       | images           | 1232 kB |
| ores       | image_tags       | 176 kB  |
| ores       | currencies       | 96 kB   |
| ores       | currency_images  | 88 kB   |
| ores       | roles            | 72 kB   |
| ores       | tags             | 72 kB   |
| ores       | role_permissions | 64 kB   |
| ores       | permissions      | 56 kB   |
| ores       | feature_flags    | 56 kB   |
| ores       | sessions         | 48 kB   |
| ores       | accounts         | 48 kB   |
| ores       | account_roles    | 40 kB   |
| ores       | login_info       | 32 kB   |
| ores       | ip2country       | 16 kB   |