Smarts NCM: How do I find out the size of the tables in Smarts NCM (Voyence) database?

Products

• VMware

Environment

VMware Smart Assurance - NCM

Resolution

How do I find out the size of the tables in Smarts Network Configuration Manager (Smarts NCM/Voyence) database?

To find out the size of the tables in the Smarts NCM (Voyence) database, do the following:

1. Launch a command prompt and log into the postgres with the following command sequence:
   
   su - pgdba
   psql voyencedb voyence
   
    
2. Once logged in, run the following SQL select command:
   
   select * from cm_calculate_table_sizes;
   
   
   The above command should produce output similar to the following for all of the tables in the database:
   
                      relation_name                                          " table_size_pretty " table_size
   --------------------------------------------------------------+-------------------+------------
    network_advisor.na_vulnerability_definition             " 1688 kB           "    1728512
    voyence.cm_config_audit_test                                  " 840 kB            "     860160
    network_advisor.na_condition                                  " 536 kB            "     548864
    voyence.cm_task_action                                           " 536 kB            "     548864
    voyence.cm_cel_audit_record                                   " 504 kB            "     516096
    voyence.md_column                                                  " 416 kB            "     425984
    network_advisor.na_affected_resource_criteria      " 384 kB            "     393216
    voyence.cm_template                                               " 376 kB            "     385024