pgCluu

Unused Indexes on engine_dao_tests database

List of indexes never used (idx_scan = 0).

Schema	Table	Index	Code
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)