• 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
      • 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
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache 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
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache 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
        • Size and tuples
      • Indexes statistics
        • Size and tuples
      • Buffercache 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
  • About

    Size and tuples on engine database tables

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

    Object name Size Tuples Avg width
    public.audit_log36.88 MB91144424.23
    public.vds_dynamic1.43 MB2027421.47
    public.vm_dynamic888.00 KB5221741.98
    public.vm_device832.00 KB3739227.86
    public.snapshots712.00 KB5221396.72
    public.vds_interface_statistics696.00 KB1415503.68
    public.vm_ovf_generations552.00 KB5301066.51
    public.vm_pool_map520.00 KB5101044.08
    public.vm_interface512.00 KB533983.65
    public.vm_init512.00 KB5031042.32
    public.vm_statistics456.00 KB522894.53
    public.engine_sessions424.00 KB1434176.00
    public.vds_interface368.00 KB1415266.31
    public.vm_static296.00 KB535566.55
    public.vds_statistics296.00 KB2021500.51
    public.network_attachments240.00 KB1431718.60
    public.vm_guest_agent_interfaces200.00 KB500409.60
    public.vdc_options120.00 KB822149.49
    public.schema_version112.00 KB327350.73
    public.vm_interface_statistics104.00 KB528201.70
    aaa_jdbc.users64.00 KB232768.00
    public.command_entities56.00 KB0-
    public.vds_spm_id_map40.00 KB189216.72
    public.vds_static40.00 KB202202.77
    public.host_device32.00 KB200163.84
    public.roles_groups24.00 KB42158.38
    public.storage_domains_ovf_info24.00 KB0-
    public.event_map16.00 KB39420.10
    public.vm_icon_defaults16.00 KB40409.60
    pg_temp_37.tt_vm_pool_group8.00 KB0-
    pg_temp_37.tt_vm_pool_running8.00 KB0-
    public.repo_file_meta_data8.00 KB0-
    aaa_jdbc.failed_logins8.00 KB0-
    public.async_tasks_entities8.00 KB0-
    pg_temp_37.tt_vm_pool_preresult8.00 KB0-
    public.base_disks8.00 KB0-
    pg_temp_84.tt_vm_pool_group8.00 KB0-
    public.network8.00 KB18192.00
    aaa_jdbc.user_attributes8.00 KB0-
    public.business_entity_snapshot8.00 KB0-
    public.providers8.00 KB0-
    public.vds_groups8.00 KB18192.00
    public.permissions8.00 KB71170.29
    public.images8.00 KB28292.57
    public.numa_node8.00 KB51638.40
    public.disk_image_dynamic8.00 KB27303.41
    public.network_cluster8.00 KB42048.00
    pg_temp_99.tt_vm_pool_result8.00 KB0-
    pg_temp_84.tt_vm_pool_result8.00 KB0-
    public.storage_domain_dynamic8.00 KB24096.00
    public.storage_domain_static8.00 KB0-
    public.gluster_config_master8.00 KB0-
    public.object_column_white_list8.00 KB9685.33
    public.job_subject_entity8.00 KB0-
    pg_temp_84.tt_vm_pool_running8.00 KB0-
    public.policy_units8.00 KB0-
    public.host_nic_vfs_config8.00 KB0-
    public.gluster_services8.00 KB0-
    aaa_jdbc.schema_version8.00 KB0-
    public.job8.00 KB0-
    pg_temp_16.tt_vm_pool_preresult8.00 KB0-
    pg_temp_16.tt_vm_pool_group8.00 KB0-
    public.dwh_history_timekeeping8.00 KB71170.29
    public.numa_node_cpu_map8.00 KB20409.60
    pg_temp_99.tt_vm_pool_running8.00 KB0-
    public.storage_pool_iso_map8.00 KB18192.00
    public.ad_groups8.00 KB18192.00
    public.step8.00 KB0-
    public.action_version_map8.00 KB0-
    aaa_jdbc.settings8.00 KB0-
    public.mac_pool_ranges8.00 KB0-
    public.qrtz_locks8.00 KB0-
    public.async_tasks8.00 KB0-
    public.gluster_service_types8.00 KB0-
    public.vnic_profiles8.00 KB18192.00
    public.roles8.00 KB0-
    public.vm_host_pinning_map8.00 KB0-
    public.image_storage_domain_map8.00 KB0-
    public.vds_cpu_statistics8.00 KB20409.60
    pg_temp_99.tt_vm_pool_preresult8.00 KB0-
    public.vm_pools8.00 KB0-
    public.disk_profiles8.00 KB0-
    public.cluster_policies8.00 KB0-
    public.cluster_policy_units8.00 KB60136.53
    pg_temp_37.tt_vm_pool_result8.00 KB0-
    public.storage_server_connections8.00 KB0-
    aaa_jdbc.user_password_history8.00 KB0-
    public.cpu_profiles8.00 KB0-
    pg_temp_84.tt_vm_pool_preresult8.00 KB0-
    public.storage_pool8.00 KB18192.00
    pg_temp_99.tt_vm_pool_group8.00 KB0-
    public.vm_icons8.00 KB63130.03
    pg_temp_16.tt_vm_pool_result8.00 KB0-
    public.users8.00 KB24096.00
    public.mac_pools8.00 KB0-
    pg_temp_16.tt_vm_pool_running8.00 KB0-
    public.cluster_features8.00 KB0-
    public.dwh_osinfo8.00 KB40204.80
    pg_toast.pg_toast_8132492.46 MB8543021.64
    pg_toast.pg_toast_26181.06 MB2534403.60
    pg_toast.pg_toast_8156231.04 MB0-
    pg_toast.pg_toast_2619192.00 KB395041.23
    pg_toast.pg_toast_81313588.00 KB245056.00
    pg_toast.pg_toast_125564.00 KB79362.29
    pg_toast.pg_toast_81452140.00 KB0-
    pg_toast.pg_toast_8130328.00 KB0-
    pg_toast.pg_toast_8148138.00 KB0-

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.