• 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
      • Statements 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
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
      • Indexes statistics
      • Buffercache Statistics
      • Statements 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
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Task list
    • Run queue
    • Context switches
    • Tasks created per second
    • Blocks
    • Transfers per second
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • luks-9a431792-a6b7-43f9-9f68-b77a9e4784ba
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-root
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-swap
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • fedora_dhcp131--31-home
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop0
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • loop1
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
      • docker-253:1-632-pool
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average service time
    • Network
      • wlp4s0
        • Network utilization
        • Network errors
      • virbr0-nic
        • Network utilization
        • Network errors
      • docker0
        • Network utilization
        • Network errors
      • bond0
        • Network utilization
        • Network errors
      • virbr0
        • Network utilization
        • Network errors
      • lo
        • Network utilization
        • Network errors
      • em1
        • Network utilization
        • Network errors
  • About

    Unused Indexes on engine database

    List of indexes never used (idx_scan = 0).

    Schema Table Index Code
    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_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)
    publiccluster_featuresidx_cluster_features_version_and_categoryCREATE INDEX idx_cluster_features_version_and_category ON cluster_features USING btree (category. version)
    publicengine_sessionsidx_engine_session_session_idCREATE INDEX idx_engine_session_session_id ON engine_sessions USING btree (engine_session_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)
    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)
    publicjobidx_job_start_timeCREATE INDEX idx_job_start_time ON job USING btree (start_time)
    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)
    publicnuma_nodeidx_numa_node_vds_idCREATE INDEX idx_numa_node_vds_id ON numa_node USING btree (vds_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_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_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)
    publicrolesidx_roles__app_modeCREATE INDEX idx_roles__app_mode ON roles USING btree (app_mode)
    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)
    publicuser_profilesidx_user_profiles_user_idCREATE INDEX idx_user_profiles_user_id ON user_profiles USING btree (user_id)
    publicvds_cpu_statisticsidx_vds_cpu_statistics_vds_idCREATE INDEX idx_vds_cpu_statistics_vds_id ON vds_cpu_statistics USING btree (vds_id)
    publicvm_interfaceidx_vm_interface_vnic_profile_idCREATE INDEX idx_vm_interface_vnic_profile_id ON vm_interface USING btree (vnic_profile_id)
    publicvm_staticidx_vm_static_cpu_profile_idCREATE INDEX idx_vm_static_cpu_profile_id ON vm_static USING btree (cpu_profile_id)
    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.