freestyle_confidential=# SELECT relpages * 8192 AS size_in_bytes, relname FROM pg_class WHERE relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'public') order by size_in_bytes desc;
 size_in_bytes |              relname
---------------+-----------------------------------
       1220608 | file
        950272 | unq_bundled_file
        573440 | file_pkey
        557056 | bundled_file
        507904 | file_version
        507904 | heading_project_id_key
        450560 | temp_file_upload
        311296 | file_version_pkey
        303104 | heading
        262144 | file_change_history
        245760 | temp_file_upload_pkey
        196608 | user_project_pkey
        155648 | user_project
        139264 | heading_pkey
        131072 | html_for_swf_pkey
        106496 | html_for_swf
         90112 | users
         65536 | file_attribute
         40960 | users_username_key
         32768 | users_pkey
         32768 | project
         32768 | project_history
         16384 | client_pkey
         16384 | client_client_name_key
         16384 | account_mgr_user_client_pkey
         16384 | section_pkey
         16384 | section_section_name_key
         16384 | project_pkey
          8192 | client_client_id_seq
          8192 | users_user_id_seq
          8192 | comment
          8192 | account_mgr_user_client
          8192 | project_project_id_seq
          8192 | temp_file_upload_temp_file_id_seq
          8192 | heading_heading_id_seq
          8192 | client
          8192 | section
          8192 | file_file_id_seq