Bookmarked Queries

List Table Sizes

SELECT
    c.relname AS name,
    pg_size_pretty(pg_total_relation_size(c.oid)) AS total_size,
    pg_size_pretty(pg_table_size(c.oid)) AS table_size,
    pg_size_pretty(pg_indexes_size(c.oid)) AS indexes_size
FROM pg_class c
LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace)
WHERE
    n.nspname NOT IN ('pg_catalog', 'information_schema')
    AND n.nspname !~ '^pg_toast'
    AND c.relkind = 'r'
ORDER BY pg_total_relation_size(c.oid) DESC;

      name      | total_size | table_size | indexes_size
----------------+------------+------------+--------------
 boarding_pass  | 3359 MB    | 2433 MB    | 926 MB
 passenger      | 2421 MB    | 1757 MB    | 664 MB
 booking_leg    | 1533 MB    | 1061 MB    | 472 MB
 booking        | 1032 MB    | 718 MB     | 314 MB
 account        | 121 MB     | 84 MB      | 36 MB
 flight         | 87 MB      | 67 MB      | 19 MB
 phone          | 61 MB      | 43 MB      | 19 MB
 frequent_flyer | 19 MB      | 14 MB      | 4624 kB
 airport        | 152 kB     | 112 kB     | 40 kB
 aircraft       | 32 kB      | 16 kB      | 16 kB
(10 rows)