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

    Size and tuples on mantis database indexes

    Disk space used by the index with number of rows at end of the audit.

    Object name Type Size Tuples Avg width
    pg_toast.pg_toast_77805_indexindexes1.71 MB7862922.82
    public.idx_history_user_idindexes864.00 KB4522319.56
    public.idx_bug_history_bug_idindexes856.00 KB4522319.38
    public.mantis_bug_history_table_pkeyindexes816.00 KB4522318.48
    public.idx_bugindexes408.00 KB2087520.01
    public.idx_last_modindexes392.00 KB2087519.23
    public.mantis_bugnote_text_table_pkeyindexes392.00 KB2087519.23
    public.mantis_bugnote_table_pkeyindexes384.00 KB2087518.84
    public.idx_bug_sponsorship_totalindexes88.00 KB334526.94
    public.idx_bug_fixed_in_versionindexes88.00 KB334526.94
    public.idx_diskfileindexes80.00 KB115770.80
    public.mantis_bug_text_table_pkeyindexes80.00 KB332124.67
    public.idx_projectindexes80.00 KB334524.49
    public.idx_bug_statusindexes80.00 KB334524.49
    public.mantis_bug_table_pkeyindexes80.00 KB334524.49
    public.idx_user_cookie_stringindexes72.00 KB633116.47
    public.mantis_custom_field_string_table_pkeyindexes56.00 KB115549.65
    public.idx_bug_rev_typeindexes48.00 KB122040.29
    public.idx_bug_rev_id_timeindexes48.00 KB122040.29
    public.idx_bug_file_bug_idindexes40.00 KB115735.40
    public.idx_custom_field_bugindexes40.00 KB115535.46
    public.mantis_bug_file_table_pkeyindexes40.00 KB115735.40
    public.mantis_bug_revision_table_pkeyindexes40.00 KB122033.57
    pg_toast.pg_toast_78017_indexindexes32.00 KB171927.53
    public.idx_user_usernameindexes32.00 KB63351.77
    public.mantis_user_table_pkeyindexes32.00 KB63351.77
    public.idx_enableindexes32.00 KB63351.77
    public.idx_accessindexes32.00 KB63351.77
    public.mantis_filters_table_pkeyindexes32.00 KB76043.12
    public.idx_category_project_nameindexes32.00 KB41079.92
    public.idx_project_nameindexes16.00 KB114143.72
    public.mantis_custom_field_table_pkeyindexes16.00 KB72340.57
    public.mantis_email_table_pkeyindexes16.00 KB121365.33
    public.idx_project_hierarchy_parent_idindexes16.00 KB72340.57
    public.mantis_tokens_table_pkeyindexes16.00 KB43381.02
    public.mantis_project_table_pkeyindexes16.00 KB114143.72
    public.mantis_news_table_pkeyindexes16.00 KB116384.00
    pg_toast.pg_toast_77865_indexindexes16.00 KB126130.03
    public.mantis_plugin_table_pkeyindexes16.00 KB28192.00
    public.mantis_user_profile_table_pkeyindexes16.00 KB82048.00
    pg_toast.pg_toast_77948_indexindexes16.00 KB36744.64
    pg_toast.pg_toast_2619_indexindexes16.00 KB84195.05
    public.idx_project_viewindexes16.00 KB114143.72
    public.mantis_category_table_pkeyindexes16.00 KB41039.96
    pg_toast.pg_toast_2618_indexindexes16.00 KB18091.02
    public.mantis_bug_relationship_table_pkeyindexes16.00 KB96170.67
    pg_toast.pg_toast_77920_indexindexes16.00 KB20579.92
    public.idx_project_hierarchy_child_idindexes16.00 KB72340.57
    public.idx_project_userindexes16.00 KB33748.62
    public.idx_project_versionindexes16.00 KB28192.00
    public.idx_typeownerindexes16.00 KB43381.02
    public.mantis_project_user_list_table_pkeyindexes16.00 KB33748.62
    public.idx_relationship_sourceindexes16.00 KB96170.67
    public.idx_relationship_destinationindexes16.00 KB96170.67
    public.mantis_project_version_table_pkeyindexes16.00 KB28192.00
    public.mantis_config_table_pkeyindexes16.00 KB161024.00
    public.mantis_bug_monitor_table_pkeyindexes16.00 KB19862.32
    public.idx_custom_field_nameindexes16.00 KB72340.57
    public.mantis_custom_field_project_table_pkeyindexes16.00 KB44372.36
    public.mantis_user_pref_table_pkeyindexes16.00 KB42838.28
    pg_toast.pg_toast_78088_indexindexes8.00 KB0-
    pg_toast.pg_toast_2609_indexindexes8.00 KB0-
    pg_toast.pg_toast_78175_indexindexes8.00 KB0-
    pg_toast.pg_toast_11635_indexindexes8.00 KB0-
    pg_toast.pg_toast_11650_indexindexes8.00 KB0-
    pg_toast.pg_toast_1255_indexindexes8.00 KB0-
    public.mantis_project_file_table_pkeyindexes8.00 KB0-
    pg_toast.pg_toast_11620_indexindexes8.00 KB0-
    pg_toast.pg_toast_77991_indexindexes8.00 KB0-
    pg_toast.pg_toast_2606_indexindexes8.00 KB0-
    public.idx_bug_tag_tag_idindexes8.00 KB0-
    pg_toast.pg_toast_77966_indexindexes8.00 KB0-
    pg_toast.pg_toast_78064_indexindexes8.00 KB0-
    pg_toast.pg_toast_78118_indexindexes8.00 KB0-
    public.idx_sponsorship_bug_idindexes8.00 KB0-
    pg_toast.pg_toast_78028_indexindexes8.00 KB0-
    pg_toast.pg_toast_2620_indexindexes8.00 KB0-
    public.mantis_user_print_pref_table_pkeyindexes8.00 KB0-
    pg_toast.pg_toast_78147_indexindexes8.00 KB0-
    pg_toast.pg_toast_2604_indexindexes8.00 KB0-
    pg_toast.pg_toast_78228_indexindexes8.00 KB0-
    pg_toast.pg_toast_11645_indexindexes8.00 KB0-
    pg_toast.pg_toast_78041_indexindexes8.00 KB0-
    pg_toast.pg_toast_11640_indexindexes8.00 KB0-
    pg_toast.pg_toast_3596_indexindexes8.00 KB0-
    pg_toast.pg_toast_77828_indexindexes8.00 KB0-
    pg_toast.pg_toast_2396_indexindexes8.00 KB0-
    public.idx_tag_nameindexes8.00 KB0-
    pg_toast.pg_toast_11630_indexindexes8.00 KB0-
    pg_toast.pg_toast_11625_indexindexes8.00 KB0-
    public.idx_sponsorship_user_idindexes8.00 KB0-
    public.mantis_sponsorship_table_pkeyindexes8.00 KB0-
    public.mantis_tag_table_pkeyindexes8.00 KB0-
    pg_toast.pg_toast_2964_indexindexes8.00 KB0-
    public.mantis_bug_tag_table_pkeyindexes8.00 KB0-

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.