Index read/fetch on mantis database indexes
Number of index entries returned by index scans, and number of live table rows fetched by simple index scans using that index during the audit period
| Schema.Table.Index | Index scan | Index entries returned | Live table rows fetched |
|---|---|---|---|
| public.mantis_bug_file_table.idx_bug_file_bug_id | 65 | 25608 | 228 |
| public.mantis_bug_file_table.mantis_bug_file_table_pkey | 17 | 17 | 17 |
| public.mantis_bug_history_table.idx_bug_history_bug_id | 259 | 2619 | 2501 |
| public.mantis_bug_monitor_table.mantis_bug_monitor_table_pkey | 64 | 64 | 64 |
| public.mantis_bug_relationship_table.idx_relationship_destination | 522 | 522 | 522 |
| public.mantis_bug_relationship_table.idx_relationship_source | 518 | 518 | 518 |
| public.mantis_bug_revision_table.idx_bug_rev_id_time | 5 | 5 | 5 |
| public.mantis_bug_revision_table.mantis_bug_revision_table_pkey | 24 | 24 | 24 |
| public.mantis_bug_table.idx_bug_status | 219 | 6714 | 3779 |
| public.mantis_bug_table.idx_project | 75 | 12686 | 0 |
| public.mantis_bug_table.mantis_bug_table_pkey | 420 | 428 | 200 |
| public.mantis_bug_text_table.mantis_bug_text_table_pkey | 212 | 212 | 212 |
| public.mantis_bugnote_table.idx_bug | 494 | 5564 | 706 |
| public.mantis_bugnote_table.mantis_bugnote_table_pkey | 187 | 49 | 40 |
| public.mantis_bugnote_text_table.mantis_bugnote_text_table_pkey | 26088 | 26040 | 26040 |
| public.mantis_category_table.idx_category_project_name | 25 | 94 | 2 |
| public.mantis_category_table.mantis_category_table_pkey | 56 | 56 | 56 |
| public.mantis_custom_field_project_table.mantis_custom_field_project_table_pkey | 194 | 194 | 194 |
| public.mantis_custom_field_string_table.idx_custom_field_bug | 17 | 15 | 15 |
| public.mantis_custom_field_table.mantis_custom_field_table_pkey | 172 | 172 | 172 |
| public.mantis_email_table.mantis_email_table_pkey | 252 | 252 | 252 |
| public.mantis_filters_table.mantis_filters_table_pkey | 35 | 36 | 34 |
| public.mantis_project_hierarchy_table.idx_project_hierarchy_child_id | 444 | 416 | 416 |
| public.mantis_project_table.mantis_project_table_pkey | 150 | 150 | 150 |
| public.mantis_project_user_list_table.idx_project_user | 296 | 296 | 296 |
| public.mantis_project_user_list_table.mantis_project_user_list_table_pkey | 261 | 948 | 148 |
| public.mantis_sponsorship_table.idx_sponsorship_bug_id | 2 | 0 | 0 |
| public.mantis_user_table.idx_access | 44 | 880 | 0 |
| public.mantis_user_table.idx_user_cookie_string | 144 | 135 | 129 |
| public.mantis_user_table.idx_user_username | 38 | 39 | 38 |
| public.mantis_user_table.mantis_user_table_pkey | 1045 | 1045 | 316 |