Database Table Size

This report provides statistical information on the current size and growth of database tables based on the type of data in them.

The data collector polls for this data at once a day at 2:00 AM.

Note: After installation or upgrade is completed, data may not be available in this report until up to 1 hour later.

Data displayed in this report is specific to the currently selected data group and date range.

If the date range is more than a single day, the Daily Percentage Growth chart is added to the right of the Row Count chart. Charted growth for the selected data group is displayed across the configured date range.

A data group is a loose organization of database tables based upon the type of data that they contain. Available data groups include the following:

Data Group: Description
Aggregation: Data that has been collected by the Data Collector from each Canister in the environment and then aggregated for reporting purposes.
Dimension: Fact data (event + dimension value) stored for each occurrence of each event.
Performance: Performance data is stored for individual hits captured by the Discover system

For the selected data group, the detail table is updated with statistics from each relevant database table for each date in the selected date range. Listed fields include the following:

Field

Description

Date

Date when report information was collected for the database table

Table

The database table to which the row of data applies

Related Object

The system object that is associated with the table, depending on the data group:

For Dimension tables: the Dimension name.
For Aggregation tables: event and maybe report group name.
For Performance tables: no related objects

Row Count

Number of rows in the table for the listed date

Data Size (MB)

Size of data in megabytes in the table for the listed date

Index Size (MB)

Size of index data in megabytes in the table for the listed date

Unused Size (MB)

Size available for the table in megabytes for the listed date

Total Size (MB)

Total size of database table in megabytes, including data and index for the listed date

Avg Bytes per Row

Average number of bytes per table row

Avg Data Bytes per Row

Average number of data bytes per table row

Avg Index Bytes per Row

Average number of index bytes per table row

Daily Avg Growth (MB)

Average daily growth of database table in megabytes over the selected date range

Daily % Growth

Percentage of growth in database table size from the previous day

This value is zero if the date range is a single date or if no data is available.

Daily Delta (MB)

Change in database table size in megabytes from the previous day

Daily Delta Rows

Change in number of rows in the database table from the previous day

Monthly % Growth

Percentage of growth in database table size from the previous month

This value is zero if the date range is less than two months or if no data is available.

Monthly Delta (MB)

Change in database table size in megabytes from the previous month

Monthly Delta Rows

Change in number of rows in the database table from the previous month