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:
[dbadmin@vertica8 ~]$ /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 [dbadmin@vertica8 ~]$ 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 [dbadmin@vertica8 ~]$ 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!