How to retrieve the size of all columns in the database?

To retrieve the column size of the database, use an internal gogo command that will dump the detailed size of each column.

GoGo command
generateColumnSizeReport <checkpointName (tt) to analyse>

This gogo command lists all the columns that exist in a chekcpoint and compute their size on disk. The output, printed on the gogo shell, is a csv like format than can be loaded in Excel for analysis

This gogo command can retrieve the column size for KI stores only, HV stores are not currently supported.

This command may take a long time to be executed since every database file will be read. Eg if the database takes 1 To and the disk speed is 100 Mo/s, the command will takes 3 hours.

output example

Related Links