The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Database Storage - Raw and Compressed Size

Jim_KnicelyJim_Knicely Administrator
edited October 2018 in Tips from the Team

One of the files generated by the /opt/vertica/scripts/collect_diag_dump.sh script details the raw and compressed size for every table in the Vertica database.

At the bottom of the report there is a “total” line that shows the database raw and compressed size!

Example:

[[email protected] ~]$ /opt/vertica/scripts/collect_diag_dump.sh -c -s false
Database Password:
Exporting profiling data........ Done
Exporting catalog and design.. Done
Computing compression  Done
Forming archive file  Done
Diagnostics dump available at ./diag_dump_20181008102602.tar.gz

[[email protected] ~]$ tar -xvzf ./diag_dump_20181008102602.tar.gz
tmp/Out_20181008102602/
tmp/Out_20181008102602/execution_engine_profiling_plans
tmp/Out_20181008102602/out_execution_engine_profiles
tmp/Out_20181008102602/out_dc_plans
tmp/Out_20181008102602/out_dc_plan_steps
tmp/Out_20181008102602/out_dc_plan_step_properties
tmp/Out_20181008102602/out_dc_plan_step_output_schema
tmp/Out_20181008102602/out_dc_plan_parents
tmp/Out_20181008102602/design
tmp/Out_20181008102602/planning_objects
tmp/Out_20181008102602/version
tmp/Out_20181008102602/compression

[[email protected] ~]$ cat tmp/Out_20181008102602/compression
                                TableName     PjCnt    PjType            RowCount         RawSize(MB)         Vertica(MB)         Compr.Ratio
=============================================================================================================================================
                              public.test         1         S           268435456              986.18              257.74                3.83
                   some_schema.some_table         1         S             4194304                8.00                0.02              400.00
_____________________________________________________________________________________________________________________________________________
                                    TOTAL                                                      994.18              257.76                3.86 

Helpful links:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Diagnostics/ExportingProfilingData.htm

Have fun!

Comments

  • Is this script also work for the Vertica EON mode ?
    Your response is highly appreciated!

Sign In or Register to comment.