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_Knicely
Administrator
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!
1
Comments
Is this script also work for the Vertica EON mode ?
Your response is highly appreciated!