Size and tuples on mantis database indexes
Disk space used by the index with number of rows at end of the audit.
| Object name | Type | Size | Tuples | Avg width |
|---|---|---|---|---|
| pg_toast.pg_toast_77805_index | indexes | 1.71 MB | 78629 | 22.82 |
| public.idx_history_user_id | indexes | 864.00 KB | 45223 | 19.56 |
| public.idx_bug_history_bug_id | indexes | 856.00 KB | 45223 | 19.38 |
| public.mantis_bug_history_table_pkey | indexes | 816.00 KB | 45223 | 18.48 |
| public.idx_bug | indexes | 408.00 KB | 20875 | 20.01 |
| public.idx_last_mod | indexes | 392.00 KB | 20875 | 19.23 |
| public.mantis_bugnote_text_table_pkey | indexes | 392.00 KB | 20875 | 19.23 |
| public.mantis_bugnote_table_pkey | indexes | 384.00 KB | 20875 | 18.84 |
| public.idx_bug_sponsorship_total | indexes | 88.00 KB | 3345 | 26.94 |
| public.idx_bug_fixed_in_version | indexes | 88.00 KB | 3345 | 26.94 |
| public.idx_diskfile | indexes | 80.00 KB | 1157 | 70.80 |
| public.mantis_bug_text_table_pkey | indexes | 80.00 KB | 3321 | 24.67 |
| public.idx_project | indexes | 80.00 KB | 3345 | 24.49 |
| public.idx_bug_status | indexes | 80.00 KB | 3345 | 24.49 |
| public.mantis_bug_table_pkey | indexes | 80.00 KB | 3345 | 24.49 |
| public.idx_user_cookie_string | indexes | 72.00 KB | 633 | 116.47 |
| public.mantis_custom_field_string_table_pkey | indexes | 56.00 KB | 1155 | 49.65 |
| public.idx_bug_rev_type | indexes | 48.00 KB | 1220 | 40.29 |
| public.idx_bug_rev_id_time | indexes | 48.00 KB | 1220 | 40.29 |
| public.idx_bug_file_bug_id | indexes | 40.00 KB | 1157 | 35.40 |
| public.idx_custom_field_bug | indexes | 40.00 KB | 1155 | 35.46 |
| public.mantis_bug_file_table_pkey | indexes | 40.00 KB | 1157 | 35.40 |
| public.mantis_bug_revision_table_pkey | indexes | 40.00 KB | 1220 | 33.57 |
| pg_toast.pg_toast_78017_index | indexes | 32.00 KB | 17 | 1927.53 |
| public.idx_user_username | indexes | 32.00 KB | 633 | 51.77 |
| public.mantis_user_table_pkey | indexes | 32.00 KB | 633 | 51.77 |
| public.idx_enable | indexes | 32.00 KB | 633 | 51.77 |
| public.idx_access | indexes | 32.00 KB | 633 | 51.77 |
| public.mantis_filters_table_pkey | indexes | 32.00 KB | 760 | 43.12 |
| public.idx_category_project_name | indexes | 32.00 KB | 410 | 79.92 |
| public.idx_project_name | indexes | 16.00 KB | 114 | 143.72 |
| public.mantis_custom_field_table_pkey | indexes | 16.00 KB | 7 | 2340.57 |
| public.mantis_email_table_pkey | indexes | 16.00 KB | 12 | 1365.33 |
| public.idx_project_hierarchy_parent_id | indexes | 16.00 KB | 7 | 2340.57 |
| public.mantis_tokens_table_pkey | indexes | 16.00 KB | 43 | 381.02 |
| public.mantis_project_table_pkey | indexes | 16.00 KB | 114 | 143.72 |
| public.mantis_news_table_pkey | indexes | 16.00 KB | 1 | 16384.00 |
| pg_toast.pg_toast_77865_index | indexes | 16.00 KB | 126 | 130.03 |
| public.mantis_plugin_table_pkey | indexes | 16.00 KB | 2 | 8192.00 |
| public.mantis_user_profile_table_pkey | indexes | 16.00 KB | 8 | 2048.00 |
| pg_toast.pg_toast_77948_index | indexes | 16.00 KB | 367 | 44.64 |
| pg_toast.pg_toast_2619_index | indexes | 16.00 KB | 84 | 195.05 |
| public.idx_project_view | indexes | 16.00 KB | 114 | 143.72 |
| public.mantis_category_table_pkey | indexes | 16.00 KB | 410 | 39.96 |
| pg_toast.pg_toast_2618_index | indexes | 16.00 KB | 180 | 91.02 |
| public.mantis_bug_relationship_table_pkey | indexes | 16.00 KB | 96 | 170.67 |
| pg_toast.pg_toast_77920_index | indexes | 16.00 KB | 205 | 79.92 |
| public.idx_project_hierarchy_child_id | indexes | 16.00 KB | 7 | 2340.57 |
| public.idx_project_user | indexes | 16.00 KB | 337 | 48.62 |
| public.idx_project_version | indexes | 16.00 KB | 2 | 8192.00 |
| public.idx_typeowner | indexes | 16.00 KB | 43 | 381.02 |
| public.mantis_project_user_list_table_pkey | indexes | 16.00 KB | 337 | 48.62 |
| public.idx_relationship_source | indexes | 16.00 KB | 96 | 170.67 |
| public.idx_relationship_destination | indexes | 16.00 KB | 96 | 170.67 |
| public.mantis_project_version_table_pkey | indexes | 16.00 KB | 2 | 8192.00 |
| public.mantis_config_table_pkey | indexes | 16.00 KB | 16 | 1024.00 |
| public.mantis_bug_monitor_table_pkey | indexes | 16.00 KB | 19 | 862.32 |
| public.idx_custom_field_name | indexes | 16.00 KB | 7 | 2340.57 |
| public.mantis_custom_field_project_table_pkey | indexes | 16.00 KB | 44 | 372.36 |
| public.mantis_user_pref_table_pkey | indexes | 16.00 KB | 428 | 38.28 |
| pg_toast.pg_toast_78088_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2609_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78175_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11635_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11650_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_1255_index | indexes | 8.00 KB | 0 | - |
| public.mantis_project_file_table_pkey | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11620_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_77991_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2606_index | indexes | 8.00 KB | 0 | - |
| public.idx_bug_tag_tag_id | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_77966_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78064_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78118_index | indexes | 8.00 KB | 0 | - |
| public.idx_sponsorship_bug_id | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78028_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2620_index | indexes | 8.00 KB | 0 | - |
| public.mantis_user_print_pref_table_pkey | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78147_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2604_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78228_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11645_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_78041_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11640_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_3596_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_77828_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2396_index | indexes | 8.00 KB | 0 | - |
| public.idx_tag_name | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11630_index | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_11625_index | indexes | 8.00 KB | 0 | - |
| public.idx_sponsorship_user_id | indexes | 8.00 KB | 0 | - |
| public.mantis_sponsorship_table_pkey | indexes | 8.00 KB | 0 | - |
| public.mantis_tag_table_pkey | indexes | 8.00 KB | 0 | - |
| pg_toast.pg_toast_2964_index | indexes | 8.00 KB | 0 | - |
| public.mantis_bug_tag_table_pkey | indexes | 8.00 KB | 0 | - |