• 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_dao_tests database tables

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

    Object name Size Tuples Avg width
    public.schema_version112.00 KB318360.65
    public.vds_dynamic32.00 KB0-
    public.vdc_options32.00 KB84096.00
    public.roles_groups24.00 KB64096.00
    public.storage_domain_static16.00 KB121365.33
    public.vm_static16.00 KB17963.76
    public.vds_groups16.00 KB91820.44
    public.host_device16.00 KB36455.11
    public.step16.00 KB131260.31
    public.qos16.00 KB131260.31
    public.vm_device16.00 KB151092.27
    public.gluster_volume_bricks16.00 KB0-
    public.event_map16.00 KB39420.10
    public.storage_server_connections16.00 KB111489.45
    public.gluster_volume_details8.00 KB0-
    public.vm_dynamic8.00 KB0-
    public.vm_interface8.00 KB0-
    public.vm_interface_statistics8.00 KB0-
    public.luns8.00 KB0-
    public.network8.00 KB18192.00
    public.base_disks8.00 KB0-
    public.async_tasks_entities8.00 KB0-
    public.repo_file_meta_data8.00 KB0-
    public.tags_vm_map8.00 KB0-
    public.libvirt_secrets8.00 KB0-
    public.audit_log8.00 KB81024.00
    public.tags_vm_pool_map8.00 KB0-
    public.vm_vds_numa_node_map8.00 KB0-
    public.vds_spm_id_map8.00 KB0-
    public.command_entities8.00 KB0-
    public.gluster_config_master8.00 KB0-
    public.storage_domain_dynamic8.00 KB10819.20
    public.affinity_groups8.00 KB0-
    public.network_cluster8.00 KB42048.00
    public.numa_node8.00 KB42048.00
    public.gluster_hooks8.00 KB0-
    public.disk_image_dynamic8.00 KB0-
    public.engine_sessions8.00 KB0-
    public.qrtz_simple_triggers8.00 KB0-
    public.vds_interface_statistics8.00 KB0-
    public.images8.00 KB13630.15
    public.permissions8.00 KB20409.60
    public.providers8.00 KB0-
    public.user_profiles8.00 KB0-
    public.business_entity_snapshot8.00 KB0-
    public.iscsi_bonds8.00 KB0-
    public.disk_lun_map8.00 KB0-
    public.supported_host_features8.00 KB0-
    public.gluster_services8.00 KB0-
    public.network_attachments8.00 KB0-
    public.host_nic_vfs_config8.00 KB0-
    public.vm_jobs8.00 KB0-
    public.gluster_volume_snapshot_schedules8.00 KB0-
    public.gluster_volume_snapshots8.00 KB0-
    public.vm_ovf_generations8.00 KB9910.22
    public.policy_units8.00 KB24096.00
    public.event_notification_hist8.00 KB0-
    public.job_subject_entity8.00 KB0-
    public.object_column_white_list8.00 KB9685.33
    public.action_version_map8.00 KB24096.00
    public.command_assoc_entities8.00 KB0-
    public.event_subscriber8.00 KB0-
    public.unregistered_ovf_of_entities8.00 KB0-
    public.ad_groups8.00 KB10819.20
    public.storage_pool_iso_map8.00 KB11744.73
    public.gluster_volume_snapshot_config8.00 KB0-
    public.numa_node_cpu_map8.00 KB81024.00
    public.tags8.00 KB32730.67
    public.dwh_history_timekeeping8.00 KB0-
    public.tags_user_map8.00 KB0-
    public.tags_vds_map8.00 KB0-
    public.vfs_config_labels8.00 KB51638.40
    public.gluster_volume_access_protocols8.00 KB0-
    public.job8.00 KB0-
    public.gluster_georep_config8.00 KB0-
    public.quota8.00 KB0-
    public.vnic_profiles8.00 KB18192.00
    public.gluster_service_types8.00 KB0-
    public.async_tasks8.00 KB0-
    public.qrtz_locks8.00 KB0-
    public.quota_limitation8.00 KB10819.20
    public.gluster_georep_session_details8.00 KB0-
    public.mac_pool_ranges8.00 KB0-
    public.snapshots8.00 KB0-
    public.lun_storage_server_connection_map8.00 KB0-
    public.qrtz_fired_triggers8.00 KB0-
    public.disk_profiles8.00 KB0-
    public.vm_pools8.00 KB0-
    public.vm_pool_map8.00 KB0-
    public.vm_guest_agent_interfaces8.00 KB0-
    public.storage_server_connection_extension8.00 KB0-
    public.gluster_volume_transport_types8.00 KB0-
    public.iscsi_bonds_storage_connections_map8.00 KB0-
    public.vds_cpu_statistics8.00 KB0-
    public.vfs_config_networks8.00 KB0-
    public.gluster_server8.00 KB0-
    public.gluster_volume_brick_details8.00 KB0-
    public.image_storage_domain_map8.00 KB61365.33
    public.vm_host_pinning_map8.00 KB32730.67
    public.roles8.00 KB61365.33
    public.cpu_profiles8.00 KB0-
    public.tags_user_group_map8.00 KB0-
    public.qrtz_job_details8.00 KB0-
    public.affinity_group_members8.00 KB0-
    public.vds_static8.00 KB0-
    public.iscsi_bonds_networks_map8.00 KB0-
    public.gluster_volume_options8.00 KB0-
    public.vm_statistics8.00 KB0-
    public.gluster_volumes8.00 KB0-
    public.qrtz_cron_triggers8.00 KB0-
    public.gluster_cluster_services8.00 KB0-
    public.cluster_policy_units8.00 KB24096.00
    public.cluster_policies8.00 KB0-
    public.vds_statistics8.00 KB0-
    public.gluster_georep_session8.00 KB0-
    public.external_variable8.00 KB0-
    public.vds_kdump_status8.00 KB0-
    public.cluster_features8.00 KB0-
    public.qrtz_triggers8.00 KB0-
    public.gluster_server_hooks8.00 KB0-
    public.object_column_white_list_sql8.00 KB0-
    public.storage_device8.00 KB0-
    public.mac_pools8.00 KB0-
    public.vm_init8.00 KB18192.00
    public.users8.00 KB18192.00
    public.vm_icons8.00 KB0-
    public.gluster_server_services8.00 KB0-
    public.storage_domains_ovf_info8.00 KB0-
    public.vds_interface8.00 KB0-
    public.storage_pool8.00 KB0-
    public.bookmarks8.00 KB0-
    public.vm_icon_defaults8.00 KB0-
    public.engine_backup_log8.00 KB0-
    public.supported_cluster_features8.00 KB0-
    pg_toast.pg_toast_26181.81 MB5853248.79
    pg_toast.pg_toast_769556168.00 KB424096.00
    pg_toast.pg_toast_261996.00 KB109830.40
    pg_toast.pg_toast_125524.00 KB0-

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.