Unused Indexes on engine2 database
List of indexes never used (idx_scan = 0).
Schema | Table | Index | Code |
---|---|---|---|
aaa_jdbc | failed_logins | failed_logins_index | CREATE INDEX failed_logins_index ON aaa_jdbc.failed_logins USING btree (minute_start) |
public | affinity_groups | idx_affinity_group_cluster_id | CREATE INDEX idx_affinity_group_cluster_id ON affinity_groups USING btree (cluster_id) |
public | async_tasks | idx_vdsm_task_id | CREATE INDEX idx_vdsm_task_id ON async_tasks USING btree (vdsm_task_id) |
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_vds_name | CREATE INDEX idx_audit_log_vds_name ON audit_log USING btree (vds_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 | business_entity_snapshot | idx_business_entity_snapshot_command_id | CREATE INDEX idx_business_entity_snapshot_command_id ON business_entity_snapshot USING btree (command_id) |
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 | command_entities | idx_root_command_id | CREATE INDEX idx_root_command_id ON command_entities USING btree (root_command_id) WHERE (root_command_id IS NOT NULL) |
public | cpu_profiles | idx_cpu_profiles_cluster_id | CREATE INDEX idx_cpu_profiles_cluster_id ON cpu_profiles USING btree (cluster_id) |
public | disk_profiles | idx_disk_profiles_storage_domain_id | CREATE INDEX idx_disk_profiles_storage_domain_id ON disk_profiles USING btree (storage_domain_id) |
public | engine_sessions | idx_engine_session_session_id | CREATE INDEX idx_engine_session_session_id ON engine_sessions USING btree (engine_session_id) |
public | fence_agents | idx_fence_agents_vds_id | CREATE INDEX idx_fence_agents_vds_id ON fence_agents USING btree (vds_id) |
public | gluster_cluster_services | idx_gluster_cluster_services_cluster_id | CREATE INDEX idx_gluster_cluster_services_cluster_id ON gluster_cluster_services USING btree (cluster_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 | gluster_volumes | idx_gluster_volumes_cluster_id | CREATE INDEX idx_gluster_volumes_cluster_id ON gluster_volumes USING btree (cluster_id) |
public | image_storage_domain_map | idx_image_storage_domain_map_image_id | CREATE INDEX idx_image_storage_domain_map_image_id ON image_storage_domain_map USING btree (image_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 | images | idx_images_images_group_id | CREATE INDEX idx_images_images_group_id ON images USING btree (image_group_id) |
public | job | idx_job_start_time | CREATE INDEX idx_job_start_time ON job USING btree (start_time) |
public | job_subject_entity | idx_job_subject_entity_entity_id | CREATE INDEX idx_job_subject_entity_entity_id ON job_subject_entity USING btree (entity_id) |
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 | network_attachments | idx_network_attachments_nic_id | CREATE INDEX idx_network_attachments_nic_id ON network_attachments USING btree (nic_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 | idx_numa_node_vm_id | CREATE INDEX idx_numa_node_vm_id ON numa_node USING btree (vm_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_tg | CREATE INDEX idx_qrtz_ft_tg ON qrtz_fired_triggers USING btree (sched_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_nft_st_misfire_grp | CREATE INDEX idx_qrtz_t_nft_st_misfire_grp ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time. trigger_group. 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 | repo_file_meta_data | idx_repo_file_file_type | CREATE INDEX idx_repo_file_file_type ON repo_file_meta_data USING btree (file_type) |
public | roles | idx_roles__app_mode | CREATE INDEX idx_roles__app_mode ON roles USING btree (app_mode) |
public | roles_groups | idx_roles_groups_action_group_id | CREATE INDEX idx_roles_groups_action_group_id ON roles_groups USING btree (action_group_id) |
public | snapshots | idx_snapshots_snapshot_type | CREATE INDEX idx_snapshots_snapshot_type ON snapshots USING btree (snapshot_type) |
public | step | idx_step_external_id | CREATE INDEX idx_step_external_id ON step USING btree (external_id) |
public | step | idx_step_job_id | CREATE INDEX idx_step_job_id ON step USING btree (job_id) |
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 | unregistered_ovf_of_entities | idx_unregistered_ovf_of_entities_storage_domain_id | CREATE INDEX idx_unregistered_ovf_of_entities_storage_domain_id ON unregistered_ovf_of_entities USING btree (storage_domain_id) |
public | user_profiles | idx_user_profiles_user_id | CREATE INDEX idx_user_profiles_user_id ON user_profiles USING btree (user_id) |
public | vdc_options | ix_vdc_options | CREATE INDEX ix_vdc_options ON vdc_options USING btree (option_name) |
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 | vds_dynamic | idx_vds_dynamic_status | CREATE INDEX idx_vds_dynamic_status ON vds_dynamic USING btree (status) |
public | vds_interface | idx_vds_interface_vds_id | CREATE INDEX idx_vds_interface_vds_id ON vds_interface USING btree (vds_id) |
public | vds_kdump_status | idx_vds_kdump_status_status | CREATE INDEX idx_vds_kdump_status_status ON vds_kdump_status USING btree (status) |
public | vfs_config_labels | idx_vfs_config_labels_vfs_config_id | CREATE INDEX idx_vfs_config_labels_vfs_config_id ON vfs_config_labels USING btree (vfs_config_id) |
public | vfs_config_networks | idx_vfs_config_networks_vfs_config_id | CREATE INDEX idx_vfs_config_networks_vfs_config_id ON vfs_config_networks USING btree (vfs_config_id) |
public | vm_device | idx_vm_device_vm_id | CREATE INDEX idx_vm_device_vm_id ON vm_device USING btree (vm_id) |
public | vm_dynamic | idx_vm_dynamic_run_on_vds | CREATE INDEX idx_vm_dynamic_run_on_vds ON vm_dynamic USING btree (run_on_vds) |
public | vm_guest_agent_interfaces | idx_vm_guest_agent_interfaces_vm_id | CREATE INDEX idx_vm_guest_agent_interfaces_vm_id ON vm_guest_agent_interfaces USING btree (vm_id) |
public | vm_interface | idx_vm_interface_vm_vmt_guid | CREATE INDEX idx_vm_interface_vm_vmt_guid ON vm_interface USING btree (vm_guid. vmt_guid) |
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_jobs | idx_vm_jobs_vm_id | CREATE INDEX idx_vm_jobs_vm_id ON vm_jobs USING btree (vm_id) |
public | vm_ovf_generations | idx_vm_ovf_generations_storage_pool_id | CREATE INDEX idx_vm_ovf_generations_storage_pool_id ON vm_ovf_generations USING btree (storage_pool_id) |
public | vm_ovf_generations | idx_vm_ovf_generations_vm_guid | CREATE INDEX idx_vm_ovf_generations_vm_guid ON vm_ovf_generations USING btree (vm_guid) |
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_static | idx_vm_static_vm_name | CREATE INDEX idx_vm_static_vm_name ON vm_static USING btree (vm_name) |
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) |