• Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilization
      • Database in shared buffers
      • Usagecount in shared buffers
      • Usagecount in dirty buffers
    • Background writer
      • Background writer buffers
      • Background writer counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Wal bytes written
      • Checkpoints counter
      • Checkpoints write time
      • Archiver stats
    • Queries Reads / Writes
      • Read tuples
      • Write ratio
      • Read vs Write queries
      • Commits vs Rollbacks
    • Replication statistics
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • engine
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • engine2
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • engine_dao_tests
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • postgres
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
      • Buffercache Statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
  • About

    Unused Indexes on engine_dao_tests database

    List of indexes never used (idx_scan = 0).

    Schema Table Index Code
    publicaffinity_groupsidx_affinity_group_cluster_idCREATE INDEX idx_affinity_group_cluster_id ON affinity_groups USING btree (cluster_id)
    publicasync_tasksidx_vdsm_task_idCREATE INDEX idx_vdsm_task_id ON async_tasks USING btree (vdsm_task_id)
    publicaudit_logidx_audit_correlation_idCREATE INDEX idx_audit_correlation_id ON audit_log USING btree (correlation_id)
    publicaudit_logidx_audit_log_gluster_volume_idCREATE INDEX idx_audit_log_gluster_volume_id ON audit_log USING btree (gluster_volume_id) WHERE (gluster_volume_id IS NOT NULL)
    publicaudit_logidx_audit_log_job_idCREATE INDEX idx_audit_log_job_id ON audit_log USING btree (job_id)
    publicaudit_logidx_audit_log_log_timeCREATE INDEX idx_audit_log_log_time ON audit_log USING btree (log_time)
    publicaudit_logidx_audit_log_storage_domain_nameCREATE INDEX idx_audit_log_storage_domain_name ON audit_log USING btree (storage_domain_name)
    publicaudit_logidx_audit_log_storage_pool_nameCREATE INDEX idx_audit_log_storage_pool_name ON audit_log USING btree (storage_pool_name)
    publicaudit_logidx_audit_log_user_nameCREATE INDEX idx_audit_log_user_name ON audit_log USING btree (user_name)
    publicaudit_logidx_audit_log_vds_nameCREATE INDEX idx_audit_log_vds_name ON audit_log USING btree (vds_name)
    publicaudit_logidx_audit_log_vm_nameCREATE INDEX idx_audit_log_vm_name ON audit_log USING btree (vm_name)
    publicaudit_logidx_audit_log_vm_template_nameCREATE INDEX idx_audit_log_vm_template_name ON audit_log USING btree (vm_template_name)
    publicbusiness_entity_snapshotidx_business_entity_snapshot_command_idCREATE INDEX idx_business_entity_snapshot_command_id ON business_entity_snapshot USING btree (command_id)
    publiccluster_featuresidx_cluster_features_version_and_categoryCREATE INDEX idx_cluster_features_version_and_category ON cluster_features USING btree (category. version)
    publiccommand_entitiesidx_root_command_idCREATE INDEX idx_root_command_id ON command_entities USING btree (root_command_id) WHERE (root_command_id IS NOT NULL)
    publiccpu_profilesidx_cpu_profiles_cluster_idCREATE INDEX idx_cpu_profiles_cluster_id ON cpu_profiles USING btree (cluster_id)
    publicdisk_profilesidx_disk_profiles_storage_domain_idCREATE INDEX idx_disk_profiles_storage_domain_id ON disk_profiles USING btree (storage_domain_id)
    publicengine_sessionsidx_engine_session_session_idCREATE INDEX idx_engine_session_session_id ON engine_sessions USING btree (engine_session_id)
    publicfence_agentsidx_fence_agents_vds_idCREATE INDEX idx_fence_agents_vds_id ON fence_agents USING btree (vds_id)
    publicgluster_cluster_servicesidx_gluster_cluster_services_cluster_idCREATE INDEX idx_gluster_cluster_services_cluster_id ON gluster_cluster_services USING btree (cluster_id)
    publicgluster_georep_sessionidx_georep_slave_host_nameCREATE INDEX idx_georep_slave_host_name ON gluster_georep_session USING btree (slave_host_name)
    publicgluster_georep_sessionidx_georep_slave_volume_nameCREATE INDEX idx_georep_slave_volume_name ON gluster_georep_session USING btree (slave_volume_name)
    publicgluster_hooksidx_gluster_hooks_cluster_idCREATE INDEX idx_gluster_hooks_cluster_id ON gluster_hooks USING btree (cluster_id)
    publicgluster_server_servicesidx_gluster_server_services_server_idCREATE INDEX idx_gluster_server_services_server_id ON gluster_server_services USING btree (server_id)
    publicgluster_volume_access_protocolsidx_gluster_volume_access_protocols_volume_idCREATE INDEX idx_gluster_volume_access_protocols_volume_id ON gluster_volume_access_protocols USING btree (volume_id)
    publicgluster_volume_bricksidx_gluster_bricks_task_idCREATE INDEX idx_gluster_bricks_task_id ON gluster_volume_bricks USING btree (task_id)
    publicgluster_volume_bricksidx_gluster_volume_bricks_volume_idCREATE INDEX idx_gluster_volume_bricks_volume_id ON gluster_volume_bricks USING btree (volume_id)
    publicgluster_volume_optionsidx_gluster_volume_options_volume_idCREATE INDEX idx_gluster_volume_options_volume_id ON gluster_volume_options USING btree (volume_id)
    publicgluster_volume_transport_typesidx_gluster_volume_transport_types_volume_idCREATE INDEX idx_gluster_volume_transport_types_volume_id ON gluster_volume_transport_types USING btree (volume_id)
    publicgluster_volumesidx_gluster_volumes_cluster_idCREATE INDEX idx_gluster_volumes_cluster_id ON gluster_volumes USING btree (cluster_id)
    publicimage_storage_domain_mapidx_image_storage_domain_map_image_idCREATE INDEX idx_image_storage_domain_map_image_id ON image_storage_domain_map USING btree (image_id)
    publicimage_storage_domain_mapidx_image_storage_domain_map_profile_idCREATE INDEX idx_image_storage_domain_map_profile_id ON image_storage_domain_map USING btree (disk_profile_id)
    publicimagesidx_images_images_group_idCREATE INDEX idx_images_images_group_id ON images USING btree (image_group_id)
    publicjobidx_job_start_timeCREATE INDEX idx_job_start_time ON job USING btree (start_time)
    publicjob_subject_entityidx_job_subject_entity_entity_idCREATE INDEX idx_job_subject_entity_entity_id ON job_subject_entity USING btree (entity_id)
    publiclibvirt_secretsidx_libvirt_secrets_provider_idCREATE INDEX idx_libvirt_secrets_provider_id ON libvirt_secrets USING btree (provider_id)
    publicnetworkidx_network_external_idCREATE INDEX idx_network_external_id ON network USING btree (provider_network_external_id) WHERE (provider_network_external_id IS NOT NULL)
    publicnetworkidx_network_storage_pool_idCREATE INDEX idx_network_storage_pool_id ON network USING btree (storage_pool_id)
    publicnetwork_attachmentsidx_network_attachments_nic_idCREATE INDEX idx_network_attachments_nic_id ON network_attachments USING btree (nic_id)
    publicnuma_nodeidx_numa_node_vds_idCREATE INDEX idx_numa_node_vds_id ON numa_node USING btree (vds_id)
    publicnuma_nodeidx_numa_node_vm_idCREATE INDEX idx_numa_node_vm_id ON numa_node USING btree (vm_id)
    publicnuma_node_cpu_mapidx_numa_node_cpu_map_numa_node_idCREATE INDEX idx_numa_node_cpu_map_numa_node_id ON numa_node_cpu_map USING btree (numa_node_id)
    publicpermissionsidx_permissions_ad_element_idCREATE INDEX idx_permissions_ad_element_id ON permissions USING btree (ad_element_id)
    publicpermissionsidx_permissions_object_idCREATE INDEX idx_permissions_object_id ON permissions USING btree (object_id)
    publicpermissionsidx_permissions_role_idCREATE INDEX idx_permissions_role_id ON permissions USING btree (role_id)
    publicqosidx_qos_storage_pool_idCREATE INDEX idx_qos_storage_pool_id ON qos USING btree (storage_pool_id)
    publicqrtz_fired_triggersidx_qrtz_ft_inst_job_req_rcvryCREATE INDEX idx_qrtz_ft_inst_job_req_rcvry ON qrtz_fired_triggers USING btree (sched_name. instance_name. requests_recovery)
    publicqrtz_fired_triggersidx_qrtz_ft_j_gCREATE INDEX idx_qrtz_ft_j_g ON qrtz_fired_triggers USING btree (sched_name. job_name. job_group)
    publicqrtz_fired_triggersidx_qrtz_ft_jgCREATE INDEX idx_qrtz_ft_jg ON qrtz_fired_triggers USING btree (sched_name. job_group)
    publicqrtz_fired_triggersidx_qrtz_ft_t_gCREATE INDEX idx_qrtz_ft_t_g ON qrtz_fired_triggers USING btree (sched_name. trigger_name. trigger_group)
    publicqrtz_fired_triggersidx_qrtz_ft_tgCREATE INDEX idx_qrtz_ft_tg ON qrtz_fired_triggers USING btree (sched_name. trigger_group)
    publicqrtz_fired_triggersidx_qrtz_ft_trig_inst_nameCREATE INDEX idx_qrtz_ft_trig_inst_name ON qrtz_fired_triggers USING btree (sched_name. instance_name)
    publicqrtz_job_detailsidx_qrtz_j_grpCREATE INDEX idx_qrtz_j_grp ON qrtz_job_details USING btree (sched_name. job_group)
    publicqrtz_job_detailsidx_qrtz_j_req_recoveryCREATE INDEX idx_qrtz_j_req_recovery ON qrtz_job_details USING btree (sched_name. requests_recovery)
    publicqrtz_triggersidx_qrtz_t_cCREATE INDEX idx_qrtz_t_c ON qrtz_triggers USING btree (sched_name. calendar_name)
    publicqrtz_triggersidx_qrtz_t_gCREATE INDEX idx_qrtz_t_g ON qrtz_triggers USING btree (sched_name. trigger_group)
    publicqrtz_triggersidx_qrtz_t_jCREATE INDEX idx_qrtz_t_j ON qrtz_triggers USING btree (sched_name. job_name. job_group)
    publicqrtz_triggersidx_qrtz_t_jgCREATE INDEX idx_qrtz_t_jg ON qrtz_triggers USING btree (sched_name. job_group)
    publicqrtz_triggersidx_qrtz_t_n_g_stateCREATE INDEX idx_qrtz_t_n_g_state ON qrtz_triggers USING btree (sched_name. trigger_group. trigger_state)
    publicqrtz_triggersidx_qrtz_t_n_stateCREATE INDEX idx_qrtz_t_n_state ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group. trigger_state)
    publicqrtz_triggersidx_qrtz_t_next_fire_timeCREATE INDEX idx_qrtz_t_next_fire_time ON qrtz_triggers USING btree (sched_name. next_fire_time)
    publicqrtz_triggersidx_qrtz_t_nft_misfireCREATE INDEX idx_qrtz_t_nft_misfire ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time)
    publicqrtz_triggersidx_qrtz_t_nft_stCREATE INDEX idx_qrtz_t_nft_st ON qrtz_triggers USING btree (sched_name. trigger_state. next_fire_time)
    publicqrtz_triggersidx_qrtz_t_nft_st_misfireCREATE INDEX idx_qrtz_t_nft_st_misfire ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time. trigger_state)
    publicqrtz_triggersidx_qrtz_t_nft_st_misfire_grpCREATE INDEX idx_qrtz_t_nft_st_misfire_grp ON qrtz_triggers USING btree (sched_name. misfire_instr. next_fire_time. trigger_group. trigger_state)
    publicqrtz_triggersidx_qrtz_t_stateCREATE INDEX idx_qrtz_t_state ON qrtz_triggers USING btree (sched_name. trigger_state)
    publicquotaidx_storage_pool_idCREATE INDEX idx_storage_pool_id ON quota USING btree (storage_pool_id) WHERE (storage_pool_id IS NOT NULL)
    publicquota_limitationidx_quota_limitation_quota_idCREATE INDEX idx_quota_limitation_quota_id ON quota_limitation USING btree (quota_id)
    publicquota_limitationidx_quota_limitation_storage_idCREATE INDEX idx_quota_limitation_storage_id ON quota_limitation USING btree (storage_id) WHERE (storage_id IS NOT NULL)
    publicquota_limitationidx_quota_limitation_vds_group_idCREATE INDEX idx_quota_limitation_vds_group_id ON quota_limitation USING btree (vds_group_id) WHERE (vds_group_id IS NOT NULL)
    publicrepo_file_meta_dataidx_repo_file_file_typeCREATE INDEX idx_repo_file_file_type ON repo_file_meta_data USING btree (file_type)
    publicrolesidx_roles__app_modeCREATE INDEX idx_roles__app_mode ON roles USING btree (app_mode)
    publicroles_groupsidx_roles_groups_action_group_idCREATE INDEX idx_roles_groups_action_group_id ON roles_groups USING btree (action_group_id)
    publicsnapshotsidx_snapshots_snapshot_typeCREATE INDEX idx_snapshots_snapshot_type ON snapshots USING btree (snapshot_type)
    publicstepidx_step_external_idCREATE INDEX idx_step_external_id ON step USING btree (external_id)
    publicstepidx_step_job_idCREATE INDEX idx_step_job_id ON step USING btree (job_id)
    publicstepidx_step_parent_step_idCREATE INDEX idx_step_parent_step_id ON step USING btree (parent_step_id)
    publicstorage_deviceidx_storage_device_vds_idCREATE INDEX idx_storage_device_vds_id ON storage_device USING btree (vds_id)
    publicunregistered_ovf_of_entitiesidx_unregistered_ovf_of_entities_storage_domain_idCREATE INDEX idx_unregistered_ovf_of_entities_storage_domain_id ON unregistered_ovf_of_entities USING btree (storage_domain_id)
    publicuser_profilesidx_user_profiles_user_idCREATE INDEX idx_user_profiles_user_id ON user_profiles USING btree (user_id)
    publicvdc_optionsix_vdc_optionsCREATE INDEX ix_vdc_options ON vdc_options USING btree (option_name)
    publicvds_cpu_statisticsidx_vds_cpu_statistics_vds_idCREATE INDEX idx_vds_cpu_statistics_vds_id ON vds_cpu_statistics USING btree (vds_id)
    publicvds_dynamicidx_vds_dynamic_statusCREATE INDEX idx_vds_dynamic_status ON vds_dynamic USING btree (status)
    publicvds_interfaceidx_vds_interface_vds_idCREATE INDEX idx_vds_interface_vds_id ON vds_interface USING btree (vds_id)
    publicvds_kdump_statusidx_vds_kdump_status_statusCREATE INDEX idx_vds_kdump_status_status ON vds_kdump_status USING btree (status)
    publicvfs_config_labelsidx_vfs_config_labels_vfs_config_idCREATE INDEX idx_vfs_config_labels_vfs_config_id ON vfs_config_labels USING btree (vfs_config_id)
    publicvfs_config_networksidx_vfs_config_networks_vfs_config_idCREATE INDEX idx_vfs_config_networks_vfs_config_id ON vfs_config_networks USING btree (vfs_config_id)
    publicvm_deviceidx_vm_device_vm_idCREATE INDEX idx_vm_device_vm_id ON vm_device USING btree (vm_id)
    publicvm_dynamicidx_vm_dynamic_run_on_vdsCREATE INDEX idx_vm_dynamic_run_on_vds ON vm_dynamic USING btree (run_on_vds)
    publicvm_guest_agent_interfacesidx_vm_guest_agent_interfaces_vm_idCREATE INDEX idx_vm_guest_agent_interfaces_vm_id ON vm_guest_agent_interfaces USING btree (vm_id)
    publicvm_interfaceidx_vm_interface_vm_vmt_guidCREATE INDEX idx_vm_interface_vm_vmt_guid ON vm_interface USING btree (vm_guid. vmt_guid)
    publicvm_interfaceidx_vm_interface_vnic_profile_idCREATE INDEX idx_vm_interface_vnic_profile_id ON vm_interface USING btree (vnic_profile_id)
    publicvm_jobsidx_vm_jobs_vm_idCREATE INDEX idx_vm_jobs_vm_id ON vm_jobs USING btree (vm_id)
    publicvm_ovf_generationsidx_vm_ovf_generations_storage_pool_idCREATE INDEX idx_vm_ovf_generations_storage_pool_id ON vm_ovf_generations USING btree (storage_pool_id)
    publicvm_ovf_generationsidx_vm_ovf_generations_vm_guidCREATE INDEX idx_vm_ovf_generations_vm_guid ON vm_ovf_generations USING btree (vm_guid)
    publicvm_staticidx_vm_static_cpu_profile_idCREATE INDEX idx_vm_static_cpu_profile_id ON vm_static USING btree (cpu_profile_id)
    publicvm_staticidx_vm_static_vm_nameCREATE INDEX idx_vm_static_vm_name ON vm_static USING btree (vm_name)
    publicvm_vds_numa_node_mapidx_vm_vds_numa_node_map_vds_numa_node_idCREATE INDEX idx_vm_vds_numa_node_map_vds_numa_node_id ON vm_vds_numa_node_map USING btree (vds_numa_node_id)
    publicvm_vds_numa_node_mapidx_vm_vds_numa_node_map_vm_numa_node_idCREATE INDEX idx_vm_vds_numa_node_map_vm_numa_node_id ON vm_vds_numa_node_map USING btree (vm_numa_node_id)
    publicvnic_profilesidx_vnic_profiles_network_idCREATE INDEX idx_vnic_profiles_network_id ON vnic_profiles USING btree (network_id)
    publicvnic_profilesidx_vnic_profiles_network_qos_idCREATE INDEX idx_vnic_profiles_network_qos_id ON vnic_profiles USING btree (network_qos_id)

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.