Unused Indexes on mantis database
List of indexes never used (idx_scan to 0)
Shema | Table | Index | Code |
---|---|---|---|
public | mantis_bug_history_table | idx_history_user_id | CREATE INDEX idx_history_user_id ON mantis_bug_history_table USING btree (user_id) |
public | mantis_bug_revision_table | idx_bug_rev_type | CREATE INDEX idx_bug_rev_type ON mantis_bug_revision_table USING btree (type) |
public | mantis_bug_table | idx_bug_fixed_in_version | CREATE INDEX idx_bug_fixed_in_version ON mantis_bug_table USING btree (fixed_in_version) |
public | mantis_bug_table | idx_bug_sponsorship_total | CREATE INDEX idx_bug_sponsorship_total ON mantis_bug_table USING btree (sponsorship_total) |
public | mantis_bug_tag_table | idx_bug_tag_tag_id | CREATE INDEX idx_bug_tag_tag_id ON mantis_bug_tag_table USING btree (tag_id) |
public | mantis_custom_field_table | idx_custom_field_name | CREATE INDEX idx_custom_field_name ON mantis_custom_field_table USING btree (name) |
public | mantis_project_hierarchy_table | idx_project_hierarchy_parent_id | CREATE INDEX idx_project_hierarchy_parent_id ON mantis_project_hierarchy_table USING btree (parent_id) |
public | mantis_project_table | idx_project_view | CREATE INDEX idx_project_view ON mantis_project_table USING btree (view_state) |
public | mantis_sponsorship_table | idx_sponsorship_user_id | CREATE INDEX idx_sponsorship_user_id ON mantis_sponsorship_table USING btree (user_id) |
public | mantis_tag_table | idx_tag_name | CREATE INDEX idx_tag_name ON mantis_tag_table USING btree (name) |
public | mantis_tokens_table | idx_typeowner | CREATE INDEX idx_typeowner ON mantis_tokens_table USING btree (type. owner) |
public | mantis_user_table | idx_enable | CREATE INDEX idx_enable ON mantis_user_table USING btree (enabled) |