Index scan ratio on mantis database tables
Number of Sequencial scan versus index scan per table during the audit period
| Schema.Table | Sequencial scan | Index scan | Index vs Sequencial |
|---|---|---|---|
| public.mantis_bug_file_table | 0 | 82 | 100.00% |
| public.mantis_bug_history_table | 100 | 259 | 72.14% |
| public.mantis_bug_monitor_table | 89 | 64 | 41.83% |
| public.mantis_bug_relationship_table | 520 | 1040 | 66.67% |
| public.mantis_bug_revision_table | 0 | 29 | 100.00% |
| public.mantis_bug_table | 153 | 714 | 82.35% |
| public.mantis_bug_text_table | 16 | 212 | 92.98% |
| public.mantis_bugnote_table | 84 | 681 | 89.02% |
| public.mantis_bugnote_text_table | 0 | 26088 | 100.00% |
| public.mantis_category_table | 2 | 81 | 97.59% |
| public.mantis_config_table | 115 | 0 | 0.00% |
| public.mantis_custom_field_project_table | 86 | 194 | 69.29% |
| public.mantis_custom_field_string_table | 17 | 17 | 50.00% |
| public.mantis_custom_field_table | 138 | 172 | 55.48% |
| public.mantis_email_table | 323 | 252 | 43.83% |
| public.mantis_filters_table | 128 | 35 | 21.47% |
| public.mantis_news_table | 2 | 0 | 0.00% |
| public.mantis_plugin_table | 115 | 0 | 0.00% |
| public.mantis_project_hierarchy_table | 161 | 444 | 73.39% |
| public.mantis_project_table | 566 | 150 | 20.95% |
| public.mantis_project_user_list_table | 193 | 557 | 74.27% |
| public.mantis_project_version_table | 97 | 0 | 0.00% |
| public.mantis_sponsorship_table | 0 | 2 | 100.00% |
| public.mantis_tag_table | 129 | 0 | 0.00% |
| public.mantis_tokens_table | 738 | 0 | 0.00% |
| public.mantis_user_pref_table | 124 | 0 | 0.00% |
| public.mantis_user_profile_table | 3 | 0 | 0.00% |
| public.mantis_user_table | 32 | 1271 | 97.54% |