Unused Indexes on engine database
List of indexes never used (idx_scan = 0).
Schema | Table | Index | Code |
---|---|---|---|
public | audit_log | idx_audit_correlation_id | CREATE INDEX idx_audit_correlation_id ON audit_log USING btree (correlation_id) |
public | audit_log | idx_audit_log_gluster_volume_id | CREATE INDEX idx_audit_log_gluster_volume_id ON audit_log USING btree (gluster_volume_id) WHERE (gluster_volume_id IS NOT NULL) |
public | audit_log | idx_audit_log_job_id | CREATE INDEX idx_audit_log_job_id ON audit_log USING btree (job_id) |
public | audit_log | idx_audit_log_log_time | CREATE INDEX idx_audit_log_log_time ON audit_log USING btree (log_time) |
public | audit_log | idx_audit_log_storage_domain_name | CREATE INDEX idx_audit_log_storage_domain_name ON audit_log USING btree (storage_domain_name) |
public | audit_log | idx_audit_log_storage_pool_name | CREATE INDEX idx_audit_log_storage_pool_name ON audit_log USING btree (storage_pool_name) |
public | audit_log | idx_audit_log_user_name | CREATE INDEX idx_audit_log_user_name ON audit_log USING btree (user_name) |
public | audit_log | idx_audit_log_vm_name | CREATE INDEX idx_audit_log_vm_name ON audit_log USING btree (vm_name) |
public | audit_log | idx_audit_log_vm_template_name | CREATE INDEX idx_audit_log_vm_template_name ON audit_log USING btree (vm_template_name) |
public | cluster_features | idx_cluster_features_version_and_category | CREATE INDEX idx_cluster_features_version_and_category ON cluster_features USING btree (category. version) |
public | engine_sessions | idx_engine_session_session_id | CREATE INDEX idx_engine_session_session_id ON engine_sessions USING btree (engine_session_id) |
public | gluster_georep_session | idx_georep_slave_host_name | CREATE INDEX idx_georep_slave_host_name ON gluster_georep_session USING btree (slave_host_name) |
public | gluster_georep_session | idx_georep_slave_volume_name | CREATE INDEX idx_georep_slave_volume_name ON gluster_georep_session USING btree (slave_volume_name) |
public | gluster_hooks | idx_gluster_hooks_cluster_id | CREATE INDEX idx_gluster_hooks_cluster_id ON gluster_hooks USING btree (cluster_id) |
public | gluster_server_services | idx_gluster_server_services_server_id | CREATE INDEX idx_gluster_server_services_server_id ON gluster_server_services USING btree (server_id) |
public | gluster_volume_access_protocols | idx_gluster_volume_access_protocols_volume_id | CREATE INDEX idx_gluster_volume_access_protocols_volume_id ON gluster_volume_access_protocols USING btree (volume_id) |
public | gluster_volume_bricks | idx_gluster_bricks_task_id | CREATE INDEX idx_gluster_bricks_task_id ON gluster_volume_bricks USING btree (task_id) |
public | gluster_volume_bricks | idx_gluster_volume_bricks_volume_id | CREATE INDEX idx_gluster_volume_bricks_volume_id ON gluster_volume_bricks USING btree (volume_id) |
public | gluster_volume_options | idx_gluster_volume_options_volume_id | CREATE INDEX idx_gluster_volume_options_volume_id ON gluster_volume_options USING btree (volume_id) |
public | gluster_volume_transport_types | idx_gluster_volume_transport_types_volume_id | CREATE INDEX idx_gluster_volume_transport_types_volume_id ON gluster_volume_transport_types USING btree (volume_id) |
public | image_storage_domain_map | idx_image_storage_domain_map_profile_id | CREATE INDEX idx_image_storage_domain_map_profile_id ON image_storage_domain_map USING btree (disk_profile_id) |
public | job | idx_job_start_time | CREATE INDEX idx_job_start_time ON job USING btree (start_time) |
public | libvirt_secrets | idx_libvirt_secrets_provider_id | CREATE INDEX idx_libvirt_secrets_provider_id ON libvirt_secrets USING btree (provider_id) |
public | network | idx_network_external_id | CREATE INDEX idx_network_external_id ON network USING btree (provider_network_external_id) WHERE (provider_network_external_id IS NOT NULL) |
public | network | idx_network_storage_pool_id | CREATE INDEX idx_network_storage_pool_id ON network USING btree (storage_pool_id) |
public | numa_node | idx_numa_node_vds_id | CREATE INDEX idx_numa_node_vds_id ON numa_node USING btree (vds_id) |
public | numa_node_cpu_map | idx_numa_node_cpu_map_numa_node_id | CREATE INDEX idx_numa_node_cpu_map_numa_node_id ON numa_node_cpu_map USING btree (numa_node_id) |
public | permissions | idx_permissions_ad_element_id | CREATE INDEX idx_permissions_ad_element_id ON permissions USING btree (ad_element_id) |
public | permissions | idx_permissions_object_id | CREATE INDEX idx_permissions_object_id ON permissions USING btree (object_id) |
public | permissions | idx_permissions_role_id | CREATE INDEX idx_permissions_role_id ON permissions USING btree (role_id) |
public | qos | idx_qos_storage_pool_id | CREATE INDEX idx_qos_storage_pool_id ON qos USING btree (storage_pool_id) |
public | qrtz_fired_triggers | idx_qrtz_ft_inst_job_req_rcvry | CREATE INDEX idx_qrtz_ft_inst_job_req_rcvry ON qrtz_fired_triggers USING btree (sched_name. instance_name. requests_recovery) |
public | qrtz_fired_triggers | idx_qrtz_ft_j_g | CREATE INDEX idx_qrtz_ft_j_g ON qrtz_fired_triggers USING btree (sched_name. job_name. job_group) |
public | qrtz_fired_triggers | idx_qrtz_ft_jg | CREATE INDEX idx_qrtz_ft_jg ON qrtz_fired_triggers USING btree (sched_name. job_group) |
public | qrtz_fired_triggers | idx_qrtz_ft_t_g | CREATE INDEX idx_qrtz_ft_t_g ON qrtz_fired_triggers USING btree (sched_name. trigger_name. trigger_group) |
public | qrtz_fired_triggers | idx_qrtz_ft_trig_inst_name | CREATE INDEX idx_qrtz_ft_trig_inst_name ON qrtz_fired_triggers USING btree (sched_name. instance_name) |
public | qrtz_job_details | idx_qrtz_j_grp | CREATE INDEX idx_qrtz_j_grp ON qrtz_job_details USING btree (sched_name. job_group) |
public | qrtz_job_details | idx_qrtz_j_req_recovery | CREATE INDEX idx_qrtz_j_req_recovery ON qrtz_job_details USING btree (sched_name. requests_recovery) |
public | qrtz_triggers | idx_qrtz_t_c | CREATE INDEX idx_qrtz_t_c ON qrtz_triggers USING btree (sched_name. calendar_name) |
public | qrtz_triggers | idx_qrtz_t_g | CREATE INDEX idx_qrtz_t_g ON qrtz_triggers USING btree (sched_name. trigger_group) |
public | qrtz_triggers | idx_qrtz_t_j | CREATE INDEX idx_qrtz_t_j ON qrtz_triggers USING btree (sched_name. job_name. job_group) |
public | qrtz_triggers | idx_qrtz_t_jg | CREATE INDEX idx_qrtz_t_jg ON qrtz_triggers USING btree (sched_name. job_group) |
public | qrtz_triggers | idx_qrtz_t_n_g_state | CREATE INDEX idx_qrtz_t_n_g_state ON qrtz_triggers USING btree (sched_name. trigger_group. trigger_state) |
public | qrtz_triggers | idx_qrtz_t_n_state | CREATE INDEX idx_qrtz_t_n_state ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group. trigger_state) |
public | qrtz_triggers | idx_qrtz_t_next_fire_time | CREATE INDEX idx_qrtz_t_next_fire_time ON qrtz_triggers USING btree (sched_name. next_fire_time) |
public | qrtz_triggers | idx_qrtz_t_nft_misfire | CREATE INDEX idx_qrtz_t_nft_misfire ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time) |
public | qrtz_triggers | idx_qrtz_t_nft_st | CREATE INDEX idx_qrtz_t_nft_st ON qrtz_triggers USING btree (sched_name. trigger_state. next_fire_time) |
public | qrtz_triggers | idx_qrtz_t_nft_st_misfire | CREATE INDEX idx_qrtz_t_nft_st_misfire ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time. trigger_state) |
public | qrtz_triggers | idx_qrtz_t_state | CREATE INDEX idx_qrtz_t_state ON qrtz_triggers USING btree (sched_name. trigger_state) |
public | quota | idx_storage_pool_id | CREATE INDEX idx_storage_pool_id ON quota USING btree (storage_pool_id) WHERE (storage_pool_id IS NOT NULL) |
public | quota_limitation | idx_quota_limitation_quota_id | CREATE INDEX idx_quota_limitation_quota_id ON quota_limitation USING btree (quota_id) |
public | quota_limitation | idx_quota_limitation_storage_id | CREATE INDEX idx_quota_limitation_storage_id ON quota_limitation USING btree (storage_id) WHERE (storage_id IS NOT NULL) |
public | quota_limitation | idx_quota_limitation_vds_group_id | CREATE INDEX idx_quota_limitation_vds_group_id ON quota_limitation USING btree (vds_group_id) WHERE (vds_group_id IS NOT NULL) |
public | roles | idx_roles__app_mode | CREATE INDEX idx_roles__app_mode ON roles USING btree (app_mode) |
public | step | idx_step_parent_step_id | CREATE INDEX idx_step_parent_step_id ON step USING btree (parent_step_id) |
public | storage_device | idx_storage_device_vds_id | CREATE INDEX idx_storage_device_vds_id ON storage_device USING btree (vds_id) |
public | user_profiles | idx_user_profiles_user_id | CREATE INDEX idx_user_profiles_user_id ON user_profiles USING btree (user_id) |
public | vds_cpu_statistics | idx_vds_cpu_statistics_vds_id | CREATE INDEX idx_vds_cpu_statistics_vds_id ON vds_cpu_statistics USING btree (vds_id) |
public | vm_interface | idx_vm_interface_vnic_profile_id | CREATE INDEX idx_vm_interface_vnic_profile_id ON vm_interface USING btree (vnic_profile_id) |
public | vm_static | idx_vm_static_cpu_profile_id | CREATE INDEX idx_vm_static_cpu_profile_id ON vm_static USING btree (cpu_profile_id) |
public | vm_vds_numa_node_map | idx_vm_vds_numa_node_map_vds_numa_node_id | CREATE INDEX idx_vm_vds_numa_node_map_vds_numa_node_id ON vm_vds_numa_node_map USING btree (vds_numa_node_id) |
public | vm_vds_numa_node_map | idx_vm_vds_numa_node_map_vm_numa_node_id | CREATE INDEX idx_vm_vds_numa_node_map_vm_numa_node_id ON vm_vds_numa_node_map USING btree (vm_numa_node_id) |
public | vnic_profiles | idx_vnic_profiles_network_id | CREATE INDEX idx_vnic_profiles_network_id ON vnic_profiles USING btree (network_id) |
public | vnic_profiles | idx_vnic_profiles_network_qos_id | CREATE INDEX idx_vnic_profiles_network_qos_id ON vnic_profiles USING btree (network_qos_id) |