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 tables

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

    Object name Type Size Tuples Avg width
    public.mantis_bugnote_text_tabletables8.04 MB20875403.81
    public.mantis_bug_history_tabletables2.59 MB4522359.96
    public.mantis_bug_text_tabletables1.94 MB3321611.75
    public.mantis_bugnote_tabletables1.38 MB2087569.07
    public.mantis_filters_tabletables1.23 MB7601703.07
    public.mantis_bug_revision_tabletables872.00 KB1220731.91
    public.mantis_bug_tabletables512.00 KB3345156.74
    public.mantis_bug_file_tabletables368.00 KB1157325.70
    public.mantis_user_tabletables136.00 KB633220.01
    public.mantis_custom_field_string_tabletables48.00 KB115542.56
    public.mantis_user_pref_tabletables48.00 KB428114.84
    public.mantis_category_tabletables24.00 KB41059.94
    public.mantis_email_tabletables24.00 KB122048.00
    public.mantis_project_user_list_tabletables16.00 KB33748.62
    public.mantis_project_tabletables16.00 KB114143.72
    public.mantis_bug_monitor_tabletables8.00 KB19431.16
    public.mantis_bug_relationship_tabletables8.00 KB9685.33
    public.mantis_config_tabletables8.00 KB16512.00
    public.mantis_news_tabletables8.00 KB18192.00
    public.mantis_project_version_tabletables8.00 KB24096.00
    public.mantis_custom_field_project_tabletables8.00 KB44186.18
    public.mantis_user_profile_tabletables8.00 KB81024.00
    public.mantis_tokens_tabletables8.00 KB43190.51
    public.mantis_custom_field_tabletables8.00 KB71170.29
    public.mantis_plugin_tabletables8.00 KB24096.00
    public.mantis_project_hierarchy_tabletables8.00 KB71170.29
    pg_toast.pg_toast_77805toast tables154.00 MB786292053.70
    pg_toast.pg_toast_77948toast tables576.00 KB3671607.15
    pg_toast.pg_toast_77920toast tables384.00 KB2051918.13
    pg_toast.pg_toast_2618toast tables336.00 KB1801911.47
    pg_toast.pg_toast_2619toast tables312.00 KB843803.43
    pg_toast.pg_toast_77865toast tables208.00 KB1261690.41
    pg_toast.pg_toast_78017toast tables32.00 KB171927.53

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.