pgCluu
  • Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilisation
      • 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
      • 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
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • dolibarr
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
    • mantis
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
    • opm
      • Database info
      • Indexes statistics
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • 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
  • pgBouncer
    • dolibarr
      • Clients / servers connections
      • Average queries duration
      • Queries per second
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Process
    • Run queue
    • Blocks
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • sdb
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji2
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji3
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji4
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji5
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji6
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji7
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji8
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • cryptswap1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
    • Network
      • lo
        • Network utilization
        • Network errors
      • eth0
        • Network utilization
        • Network errors
  • About

    Missing indexes on mantis database

    List of DDL to create missing indexes on foreign keys.

    Table Missing index
    mantis_bug_file_tableCREATE INDEX idx_mantis_bug_file_table_id ON mantis_bug_file_table (id)
    mantis_bug_history_tableCREATE INDEX idx_mantis_bug_history_table_id ON mantis_bug_history_table (id)
    mantis_bug_monitor_tableCREATE INDEX idx_mantis_bug_monitor_table_user_id_bug_id ON mantis_bug_monitor_table (user_id.bug_id)
    mantis_bug_relationship_tableCREATE INDEX idx_mantis_bug_relationship_table_id ON mantis_bug_relationship_table (id)
    mantis_bug_revision_tableCREATE INDEX idx_mantis_bug_revision_table_id ON mantis_bug_revision_table (id)
    mantis_bug_tag_tableCREATE INDEX idx_mantis_bug_tag_table_bug_id_tag_id ON mantis_bug_tag_table (bug_id.tag_id)
    mantis_bug_tableCREATE INDEX idx_mantis_bug_table_id ON mantis_bug_table (id)
    mantis_bug_text_tableCREATE INDEX idx_mantis_bug_text_table_id ON mantis_bug_text_table (id)
    mantis_bugnote_tableCREATE INDEX idx_mantis_bugnote_table_id ON mantis_bugnote_table (id)
    mantis_bugnote_text_tableCREATE INDEX idx_mantis_bugnote_text_table_id ON mantis_bugnote_text_table (id)
    mantis_category_tableCREATE INDEX idx_mantis_category_table_id ON mantis_category_table (id)
    mantis_config_tableCREATE INDEX idx_mantis_config_table_config_id_project_id_user_id ON mantis_config_table (config_id.project_id.user_id)
    mantis_custom_field_project_tableCREATE INDEX idx_mantis_custom_field_project_table_field_id_project_id ON mantis_custom_field_project_table (field_id.project_id)
    mantis_custom_field_string_tableCREATE INDEX idx_mantis_custom_field_string_table_field_id_bug_id ON mantis_custom_field_string_table (field_id.bug_id)
    mantis_email_tableCREATE INDEX idx_mantis_email_table_email_id ON mantis_email_table (email_id)
    mantis_plugin_tableCREATE INDEX idx_mantis_plugin_table_basename ON mantis_plugin_table (basename)
    mantis_project_file_tableCREATE INDEX idx_mantis_project_file_table_id ON mantis_project_file_table (id)
    mantis_project_user_list_tableCREATE INDEX idx_mantis_project_user_list_table_project_id_user_id ON mantis_project_user_list_table (project_id.user_id)
    mantis_user_profile_tableCREATE INDEX idx_mantis_user_profile_table_id ON mantis_user_profile_table (id)
    mantis_tag_tableCREATE INDEX idx_mantis_tag_table_id_name ON mantis_tag_table (id.name)
    mantis_tokens_tableCREATE INDEX idx_mantis_tokens_table_id ON mantis_tokens_table (id)
    mantis_user_print_pref_tableCREATE INDEX idx_mantis_user_print_pref_table_user_id ON mantis_user_print_pref_table (user_id)
    mantis_custom_field_tableCREATE INDEX idx_mantis_custom_field_table_id ON mantis_custom_field_table (id)
    mantis_news_tableCREATE INDEX idx_mantis_news_table_id ON mantis_news_table (id)
    mantis_project_tableCREATE INDEX idx_mantis_project_table_id ON mantis_project_table (id)
    mantis_project_version_tableCREATE INDEX idx_mantis_project_version_table_id ON mantis_project_version_table (id)
    mantis_sponsorship_tableCREATE INDEX idx_mantis_sponsorship_table_id ON mantis_sponsorship_table (id)
    mantis_user_pref_tableCREATE INDEX idx_mantis_user_pref_table_id ON mantis_user_pref_table (id)
    mantis_user_tableCREATE INDEX idx_mantis_user_table_id ON mantis_user_table (id)
    mantis_filters_tableCREATE INDEX idx_mantis_filters_table_id ON mantis_filters_table (id)

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.