• 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

    Redundant indexes on engine database

    List of useless indexes because they are redundant.

    Contained Containing
    CREATE INDEX idx_business_entity_snapshot_command_id ON business_entity_snapshot USING btree (command_id)CREATE UNIQUE INDEX uq_command_id_entity_id ON business_entity_snapshot USING btree (command_id. entity_id. entity_type. snapshot_type)
    CREATE INDEX idx_gluster_cluster_services_cluster_id ON gluster_cluster_services USING btree (cluster_id)CREATE UNIQUE INDEX pk_gluster_cluster_services ON gluster_cluster_services USING btree (cluster_id. service_type)
    CREATE INDEX idx_gluster_hooks_cluster_id ON gluster_hooks USING btree (cluster_id)CREATE UNIQUE INDEX idx_gluster_hooks_unique ON gluster_hooks USING btree (cluster_id. gluster_command. stage. name)
    CREATE INDEX idx_gluster_server_services_server_id ON gluster_server_services USING btree (server_id)CREATE UNIQUE INDEX unique_gluster_server_services_server_service ON gluster_server_services USING btree (server_id. service_id)
    CREATE INDEX idx_gluster_volume_access_protocols_volume_id ON gluster_volume_access_protocols USING btree (volume_id)CREATE UNIQUE INDEX pk_gluster_volume_access_protocols ON gluster_volume_access_protocols USING btree (volume_id. access_protocol)
    CREATE INDEX idx_gluster_volume_bricks_volume_id ON gluster_volume_bricks USING btree (volume_id)CREATE UNIQUE INDEX idx_gluster_volume_bricks_volume_server_brickdir ON gluster_volume_bricks USING btree (volume_id. server_id. brick_dir)
    CREATE INDEX idx_gluster_volume_options_volume_id ON gluster_volume_options USING btree (volume_id)CREATE UNIQUE INDEX idx_gluster_volume_options_volume_id_option_key ON gluster_volume_options USING btree (volume_id. option_key)
    CREATE INDEX idx_gluster_volume_transport_types_volume_id ON gluster_volume_transport_types USING btree (volume_id)CREATE UNIQUE INDEX pk_gluster_volume_transport_types ON gluster_volume_transport_types USING btree (volume_id. transport_type)
    CREATE INDEX idx_gluster_volumes_cluster_id ON gluster_volumes USING btree (cluster_id)CREATE UNIQUE INDEX gluster_volumes_name_unique ON gluster_volumes USING btree (cluster_id. vol_name)
    CREATE INDEX idx_image_storage_domain_map_image_id ON image_storage_domain_map USING btree (image_id)CREATE UNIQUE INDEX pk_image_storage_domain_map ON image_storage_domain_map USING btree (image_id. storage_domain_id)
    CREATE INDEX idx_permissions_ad_element_id ON permissions USING btree (ad_element_id)CREATE UNIQUE INDEX idx_combined_ad_role_object ON permissions USING btree (ad_element_id. role_id. object_id)
    CREATE INDEX idx_vds_interface_vds_id ON vds_interface USING btree (vds_id)CREATE UNIQUE INDEX vds_interface_vds_id_name_unique ON vds_interface USING btree (vds_id. name)
    CREATE INDEX idx_vm_ovf_generations_vm_guid ON vm_ovf_generations USING btree (vm_guid)CREATE UNIQUE INDEX vm_ovf_generations_pkey ON vm_ovf_generations USING btree (vm_guid)
    CREATE UNIQUE INDEX qrtz_triggers_pkey ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group)CREATE INDEX idx_qrtz_t_n_state ON qrtz_triggers USING btree (sched_name. trigger_name. trigger_group. trigger_state)
    CREATE INDEX idx_vfs_config_networks_vfs_config_id ON vfs_config_networks USING btree (vfs_config_id)CREATE UNIQUE INDEX vfs_config_networks_pk ON vfs_config_networks USING btree (vfs_config_id. network_id)
    CREATE INDEX idx_vfs_config_labels_vfs_config_id ON vfs_config_labels USING btree (vfs_config_id)CREATE UNIQUE INDEX vfs_config_labels_pk ON vfs_config_labels USING btree (vfs_config_id. label)

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.